Please enable JavaScript to view the comments powered by Disqus.


Using HLOOKUP() function to retrieve values in tables. 

Unlike vlookup that looks for values in column, HLOOKUP() looks for values in rows, and retrieves values from a given row, with exact or approximate matches. The first argument of the function is lookup_value, the second is lookup_table, the third is "row offset" and the fourth is true or false based on exact or approximate match. 

Used Functions

Category: Lookup and reference

Looks in the top row of an array and returns the value of the indicated cell


HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Lets chat on this