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: -The VLOOKUP function can search for a specific category or value in a table and return the “opposing” value from adjacent columns. HLOOKUP works exactly in the same way except that it looks horizontally rather than vertically. “V” in VLOOKUP refers to vertical and “H” in HLOOKUP refers to horizontal.

Detailed explanation-4: -Usage notes. The HLOOKUP function can locate and retrieve a value from data in a horizontal table. Like the “V” in VLOOKUP which stands for “vertical", the “H” in HLOOKUP stands for “horizontal". The lookup values must appear in the first row of the table, moving horizontally to the right.

Detailed explanation-5: -The task of the HLOOKUP function is to search for a value in the topmost row of a table, and then return a corresponding value in the same column from a row you specify.