HLOOKUP

Finds a value in the top row of a table and returns a value from the same column.

Group: Lookup

Syntax

HLOOKUP(lookup_value, table, row_number, [exact])

Example

← All of Excel Function Reference