VLOOKUP Practice

Freeintermediate 20 min4 tasks0/66 pts

Practise the full VLOOKUP routine: pick the table, count the column, use FALSE, lock the table with $ when you fill down, and wrap in IFERROR for missing values.

Syntax

VLOOKUP(F2,$A$2:$D$7,4,FALSE)

Common mistakes

Forgetting $ so the table slides down when you fill.
Leaving out FALSE on unsorted data.

VLOOKUP Function 2 More VLOOKUP Practice