LookupsFind values with VLOOKUP
VLOOKUP(what, table, column number, FALSE) finds a row by its first column and returns a value from that row.
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
9