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: -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])

Detailed explanation-3: -When you create a VLOOKUP or HLOOKUP function, you enter a range of cells, such as D2:F39. That range is called the table array argument, and an argument is simply a piece of data that a function needs in order to run. In this case, the function searches those cells for the data you’re trying to find.

Detailed explanation-4: -The “H” in HLOOKUP stands for “horizontal", and lookup values must appear in the first row of the table, moving horizontally to the right. HLOOKUP supports approximate and exact matching, and wildcards (* ?) for finding partial matches.