Which of the following functions returns a value or the reference to a value within a range based on X
And Y coordinates?
A)MATCH
B)INDEX
C)VLOOKUP
D)HLOOKUP

Question

Quizplus · Accepted Answer

The INDEX function returns a value or a reference to a value within a range based on X and Y coordinates. The first argument specifies the range, the second argument specifies the row number, and the third argument specifies the column number.

Which of the Following Functions Returns a Value or the Reference