Look up a value in a table
Find a key in one column and return the matching value from another.
The formula
=XLOOKUP("Apple", A:A, B:B)How it works
Lookup value
Apple
| A | B | |
|---|---|---|
| 1 | Fruit | Price |
| 2 | Apple | 1.20 |
| 3 | Banana | 0.50 |
| 4 | Cherry | 3.00 |
Result
1.20
Find Apple in the Fruit column, return its Price.