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 table array argument is always the second argument in a VLOOKUP or HLOOKUP function (the first is the value you’re trying to find), and the functions won’t work without it. Your first argument, the value you want to find, can be a specific value such as “41” or “smith, ” or it be a cell reference such as F2.

Detailed explanation-3: -The HLOOKUP function is used to search for a value in the top row of an array of values, and then it retrieves the value in the same column from a row you specify in the table or array.

Detailed explanation-4: -The range lookup argument of the VLOOKUP and HLOOKUP functions is the range of values to be looked up in order to determine the function’s result.