Learn how to use the VLOOKUP function to cross-reference data in this week’s Happy Computers Summer School time saving two minute video!
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. Our next public dates are:
You can also join our Happy Video Library for just £40 per year to view hundreds of time saving two minute tips!
Sign up to our mailing list below for IT training updates and offers in the footer below to receive our #TipTuesday emails each week throughout July and August!