VLOOKUP: exact match or nearest match?
The last part of VLOOKUP is TRUE or FALSE. See what each one does, and why the wrong one returns the wrong row.
Task 1FALSE finds an exact match2 questions
The last part of VLOOKUP says how to match. FALSE means an exact match: the value must be in the first column, or the answer is the error #N/A.
| A | B | C | |
|---|---|---|---|
| 1 | Code | Item | Price |
| 2 | P01 | Copier paper | 24.50 |
| 3 | P02 | Marker pens | 6.80 |
| 4 | P03 | Ring binder | 3.25 |
| 5 | P04 | Stapler | 9.40 |
| 6 | P05 | Envelopes | 12.60 |
#N/A means not available. VLOOKUP does not mind capital letters, so p02 finds P02.
Use FALSE for codes, names and invoice numbers, where a near miss would be the wrong row.
Task 2TRUE finds the nearest match below3 questions
Task 3Which one to use3 questions