The VLOOKUP function
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.
Courses are delivered in 2007, 2010, 2013, 2016.
- - 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