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.


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

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

Stay up to date

Subscribe to our mailing lists:

I would like to receive the following emails:
Mailing lists

We are collecting your email address to send you the emails you select above and we require your consent. By clicking the Subscribe button, we are treating this as your consent. To withdraw your consent, please use the unsubscribe option at the bottom of the received email(s)