ExcelHeroThe VLOOKUP function
Finds a row by its first column and returns a value from it.
In German Excel: SVERWEIS
How to write it
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])- lookup_value
- What to find.
- table_array
- The table; the first column is searched.
- col_index_num
- Which column to return, counting from 1.
- range_lookup
- FALSE for an exact match. TRUE for bands like grades.
💡 Forgetting FALSE is the most common VLOOKUP mistake.
Try it
What is the price of the product code in A8?
A
B
C
D
1
Code
Product
Price
Stock
2
P-101
Desk lamp
24.99
12
3
P-102
Notebook
3.5
240
4
P-103
Backpack
39.9
0
5
P-104
Water bottle
12
55
6
P-105
Headphones
59
8
7
8
P-104
Price is the 3rd column of A2:D6. FALSE means exact match.