VLOOKUP
The older lookup you will still meet in real files
0 of 3 done · Lesson 9 of 18
Understand
VLOOKUP has been in every workplace spreadsheet for twenty years, so you will inherit files full of it whether you like it or not. It takes a whole table and a column number, counted from the left edge of that table, which is where most of its problems come from.
=VLOOKUP(who to find, the whole table, which column, counting from the left, FALSE for an exact match, optional)
A worked example
=VLOOKUP(F1, A2:D9, 2, FALSE)
who to findthe whole tablewhich column, counting from the leftFALSE for an exact match
This returns Fernway
The sheet you are working with
| Row number | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Order | Customer | Region | Amount | Find order | 1047 |
| 2 | 1042 | Northwind | Otago | 1250 | ||
| 3 | 1043 | Kea Ltd | Waikato | 840 | ||
| 4 | 1044 | Halcyon | Otago | 2110 | ||
| 5 | 1045 | Brightsmith | Auckland | 560 | ||
| 6 | 1046 | Tuatara | Waikato | 1780 | ||
| 7 | 1047 | Fernway | Otago | 930 | ||
| 8 | 1048 | Pounamu | Nelson | 1420 | ||
| 9 | 1049 | Rimu Co | Otago | 1120 |