ExcelHeroThe XLOOKUP function
Looks up a value in one range and returns the match from another.
In German Excel: XVERWEIS
How to write it
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found])- lookup_value
- What to find.
- lookup_array
- Where to find it.
- return_array
- What to return. Can be left of the lookup column.
- if_not_found
- Optional. What to show when nothing matches.
💡 Return several columns at once and the result spills.
Try it
What does the product in B8 cost?
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
Backpack
Look in the Product column, return the Price column.