Both the HLOOKUP and VLOOKUP functions look up a value in a table and return a corresponding value from the table to the cell containing the function.

Question

Quizplus · Accepted Answer

Both the HLOOKUP and VLOOKUP functions perform a lookup in a table and return a corresponding value to the cell where the function is placed. HLOOKUP looks for a value in the top row of a table and returns a corresponding value from a row below, while VLOOKUP looks for a value in the leftmost column of a table and returns a corresponding value from a column to the right.

Both the HLOOKUP and VLOOKUP Functions Look Up a Value