VLOOKUP function
Finds a value in the first column of a table and returns a value from another column in the same row.
Syntax
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])| Argument | What it means |
|---|---|
lookup_value | The value to find, such as a product ID. |
table_array | The table to search. The lookup column must be its first column. |
col_index_num | Which column of the table to return, counting from 1. |
range_lookupoptional | Use FALSE for an exact match. Leaving it out means approximate match. |
Example
=VLOOKUP(E2,A2:C10,3,FALSE)Finds E2 in column A and returns the value from the third column (C).
Tip. Forgetting FALSE is the most common VLOOKUP mistake. XLOOKUP avoids it.
Try itType =VLOOKUP( in E2 and click cells to fill in the arguments.
Undo
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
Click a cell, then type. Right-click for rows, columns, sort and filter.
A
B
C
D
E
F
G
H
I
J
K
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Item
Qty
Price
Date
Try here
Apples
12
$0.50
2024-01-15
Bananas
30
$0.25
2024-02-29
Cherries
8
$3.20
2024-04-30
Dates
15
$2.75
2024-07-27
Figs
5
$1.90
2024-12-01