If a worksheet arranges lookup values in rows rather than columns, which function is best for retrieving data from the lookup table?
A) VLOOKUP
B) HLOOKUP
C) INDEX
D) MATCH

Question

Quizplus · Accepted Answer

HLOOKUP is the best choice for retrieving data from the lookup table arranged in rows. It works similar to VLOOKUP, but it searches for the lookup value in the first row of the table and returns the corresponding value from a specified row.

If a Worksheet Arranges Lookup Values in Rows Rather Than