Loading…
Loading…
HLOOKUP is VLOOKUP turned sideways. It searches the top row of a table for a value and returns the value from a row further down, counted by row_index_num. Use it when your headings run across the top.
Syntax
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Example: =HLOOKUP("Mar",A1:E4,2,FALSE) finds Mar in row 1 and returns the value from the 2nd row (Sales).
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.