Hlookup Tutorial in MS Excel 2007 with Example by technical Vijay



The Excel HLOOKUP function is designed for horizontal lookup. More specifically, it searches for a certain value in the first row of the table and returns another value in the same column from a row that you specify.

The HLOOKUP function is available in all versions of Microsoft Excel 2016, Excel 2013, Excel 2010, Excel 2007 and lower.
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Lookup_value (required) – the value to search for. It can be a cell reference, numeric…

Leave a Reply

Your email address will not be published. Required fields are marked *