#TipTuesday: Using VLOOKUP in MS Excel

In: BlogDate: Nov 29, 2018By: Claire Lickman

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?

Sign up here

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.

Sign up here

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!

Claire Lickman

Claire is Digital Marketing Coordinator at Happy. She has worked at Happy since 2016, and is responsible for Happy's marketing strategy, website, social media and more. Claire first heard about Happy in 2012 when she attended a mix of IT and personal development courses. These courses were life-changing and she has been a fan of Happy ever since.

More by Claire

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.