Use the ____ function when the data in the lookup table is listed horizontally in rows.
A) HLOOKUPTABLE
B) VLOOKUPTABLE
C) HLOOKUP
D) VLOOKUP

Question

Quizplus · Accepted Answer

The HLOOKUP function is used when the lookup table is in horizontal rows, with the lookup value appearing in the first row of the table. The VLOOKUP function is used when the lookup table is in vertical columns, with the lookup value appearing in the first column of the table. Therefore, the best choice for this scenario would be the HLOOKUP function.

Use the ____ Function When the Data in the Lookup