HLOOKUP function

Description

This HLOOKUP function perform lookup and retrieve data from a specific row in a table. The "H" stands for "horizontal", where is lookup the values appear in the first row of the table, moving horizontally to the right. HLOOKUP supports approximate and exact matching and close matches.

​

Objective

Obtain value in a table by matching on the first row.

​

Syntax

=HLOOKUP(value,table,row_index,[range_lookup])

​

Arguements

value - Value to lookup.

table - Table from which to retrieve data.

row_index - Row number from which to retrieve data.

range_lookup - [optional] Boolean to indicate exact match of close match. Default is True = close match.

​

​