FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find. The H in HLOOKUP stands for “Horizontal."

Detailed explanation-2: -HLOOKUP stands for Horizontal Lookup and can be used to retrieve information from a table by searching a row for the matching data and outputting from the corresponding column.

Detailed explanation-3: -Description. The Microsoft Excel HLOOKUP function performs a horizontal lookup by searching for a value in the top row of the table and returning the value in the same column based on the index number. The HLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function.

Detailed explanation-4: -The HLOOKUP function has the following syntax, with 3 required arguments, and 1 optional argument: HLOOKUP(lookup value, table array, row index num, [range lookup])