Microsoft Excel The VLOOKUP function

The VLOOKUP function

90 Mins

Excel LOOKUP functions search for a value located in the original table and returns a required value from a column or row of another table that you specify. The VLOOKUP function can also incorporate other Excel functions such as IF and MATCH to increase its calculating capability.

Required knowledge or experience:

This session is designed for users who are confident creating Absolute References formulas and range names, and using the IF Function.


Courses are delivered in 2007, 2010, 2013, 2016.

What will I learn?
Learn how to:
  • - Create a formula using the VLOOKUP function
  • - Create a VLOOKUP formula that uses Named Ranges
  • - Create a VLOOKUP formula that also includes an IF function
  • - Create a VLOOKUP formula that also includes a MATCH function
Related courses
Run this
course at
your offices
Request a quote
which course
Which level do you need?
Take our online skills assessment
Find out more
Speak to a friendly advisor


0333 344 6630

or visit our

Online Chat