How VLOOKUP works
VLOOKUP finds a code in the first column of a table and returns a cell from the same row. Learn its four parts.
Task 1The four parts of VLOOKUP4 questions
VLOOKUP looks down the first column of a table for a value. When it finds the value, it returns a cell from the same row.
- Lookup value
- what to look for, such as a product code
- Range
- the cells of the table, with the column to search on the left
- Column number
- which column of the range to return, counting from 1 on the left
- FALSE
- accept an exact match only
| 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 |
=VLOOKUP("P02",A2:C6,2,FALSE) finds P02 in column A and returns column 2 of the range, which is Marker pens. It works the same in Excel and in Google Sheets.
Task 2A cell as the lookup value4 questions