VLOOKUP Function 2

Freeintermediate 15 min4 tasks0/54 pts

The column index in VLOOKUP counts columns from the left edge of the table you give it, not from column A of the sheet. Change the number and the same lookup returns a different column. Lookup values can be numbers (like IDs) as well as text.

Syntax

VLOOKUP(lookup_value, table_array, col_index_num, FALSE)

Example: =VLOOKUP(104,A2:D7,4,FALSE) finds ID 104 in column A and returns the 4th column of A2:D7 (the salary).

Common mistakes

Counting the column number from the sheet instead of from the table.
A column index larger than the table width gives #REF!.

VLOOKUP Function VLOOKUP Practice