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 in Excel stands for ‘Horizontal Lookup’. It is a function that makes Excel search for a certain value in a row (the so called ‘table array’), in order to return a value from a different row in the same 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: -VLOOKUP allows you to search a data range that is set up vertically. HLOOKUP is the exact same function, but looks up data that has been formatted by rows instead of columns. LOOKUP and related functions are commonly used for business analytics in Excel as a way of slicing and dicing data for analysis.

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.