Excel HLOOKUP Function
Syntax
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Description
Looks for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify.
Example Excel File
Enter your email to receive the example Excel file (link valid 24h).
Become a supporter
—
download instantly, no email