Excel HLOOKUP function

Function              HLOOKUP

Description        Excel HLOOKUP function to look up and retrieve data from a specific row in array

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

value  The value to be looked up.

table  The table is the array from which to retrieve data.

row_index  The row number from which to retrieve data.

range_lookup  [optional] Gives two options, exact match or approximate match. Default = TRUE = approximate match.