ExcelHeroThe HLOOKUP function
Finds a column by its first row and returns a value from that column.
In German Excel: WVERWEIS
How to write it
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])- lookup_value
- What to look for in the first row.
- table_array
- The whole table, labels in the first row.
- row_index_num
- Which row to return: 2 is the row below the labels.
- range_lookup
- FALSE for an exact match.
💡 The sideways twin of VLOOKUP. XLOOKUP does both directions.
Try it
What does size L cost?
A
B
C
D
E
1
Size
S
M
L
XL
2
Price
8
10
12
15
3
Stock
40
25
0
9
4
5
Size
L
6
Price
The price is the 2nd row of B1:E3.