XLOOKUP function
Finds a value in one range and returns the matching value from another range.
Syntax
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found])
| Argument | What it means |
|---|---|
lookup_value | The value to find. |
lookup_array | The column or row to search. |
return_array | The column or row to return a value from. |
if_not_foundoptional | What to show when nothing matches. |
Example
=XLOOKUP(E2,A2:A10,B2:B10)
Finds E2 in A2:A10 and returns the value on the same row of B2:B10. Exact match by default.
Try itType =XLOOKUP( in E2 and click cells to fill in the arguments.
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