VLOOKUP is one of the lookup and reference functions, when you need to find things in a table or a range by row. For example, use VLOOKUP to find a price of an automotive part or the letter grade of a final average.
VLOOKUP location: Click FORMULA tab, Lookup and Reference icon in the Function Library group. Find VLOOKUP option at the bottom of the list.
VLOOKUP argument box: When you click on VLOOKUP, an argument box appears like the one below:
Taking one box at a time:
Lookup Value: The value you want to look up.
Table array. The column number in the range that contains the return value.
Col Index num (meaning Column Index Number)
Range Lookup: We do not need to use this box
EXERCISE (not graded but helpful to you if you work your way through it.)
- Prepare a simple spreadsheet like the one below.
- VLOOKUP. Authored by: Fran Wells. License: CC BY: Attribution