Video – Lookup functions in Excel covering Vlookup, Hlookup and Xlookup

Hello all. In this video tutorial, we will see the lookup functions in excel. Thanks for watching. Please help by subscribing and sharing the content.

Hlookup in Excel

Hello all. Let’s look at Hlookup function. Hlookup is a function that looks up the specified value in horizontally sorted values and returns value from specific row in the table. Syntax =hlookup(lookup_value, table_array, row_index_num, [range_lookup]) Here are certain points to note before looking at examples: Lookup value must always be located in the first rowContinue reading “Hlookup in Excel”