VLOOKUP Information

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.