Excel Forum
Similar Content
How to use the Vlookup Function in Excel
Tutorial: Full explanation of the Vlookup function in Excel, what it is, how to use it, and when you...
Vlookup Function That Searches The Entire Workbook - UDF
Macro: This UDF is a Vlookup function that searches the entire workbook in Excel. The syntax...
Vlookup to Return All Matching Results
Tutorial: Here is an Excel formula that will act like a Vlookup that returns every matching result ...



Highline Excel Class 07: VLOOKUP function formula 7 Examples


Learn about:
1)VLOOKUP to lookup an exact match
2)VLOOKUP to lookup an approximate match
3)VLOOKUP can return a value to a cell
4)VLOOKUP can return a value to a formula
5)VLOOKUP can lookup values on a different sheet (Name table and use name in VLOOKUP function)
6)Use VLOOKUP to return values from column 2 of the lookup table
7)Use VLOOKUP to return values from column 3 of the lookup table
8)Use VLOOKUP and COLUMNS function together for lookup tables with more than 2 columns

This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109





Got a Question? Ask it Here in the Forum.