#TipTuesday: Using VLOOKUP in MS Excel
Learn how to use the VLOOKUP function to cross-reference data in this week’s time-saving two-minute video!
Hi, we are Happy
We are leading a movement to create happy, empowered and productive workplaces.
How can we help you and your people to find joy in at least 80% of your work?
Vlookups to cross reference data
Why not sign up to our newsletter?
Sign up to our monthly newsletter, full of tips, tricks and news to help you to be happier and more productive at work.
The VLOOKUP function, or Vertical Look Up, is an easy way to show and automatically fill in the information you need. In our example above, Nicky will show you how to use this useful tool to automatically look up a pupil’s grade on an exam, and display the marks instead. This great tool can save you lots of time!
Want to learn more?
Join our Excel Core Level 2 course to learn additional time-saving formula, such as Conditional Formatting and CountIF. Check out our Excel Core Level 2 course page here to see the upcoming course dates and full course outline.
You can also join our Happy Video Library for just £40 per year to view hundreds of time saving two minute tips – contact us for details of group rates for organisations.