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 function that returns a value or a reference to a value within a range based on X and Y coordinates is the INDEX function. This function requires two arguments: the first argument is the range of cells to search, and the second argument is the row and column numbers of the cell to return. Therefore, the best choice for this question is B - INDEX. The other options (MATCH, VLOOKUP, and HLOOKUP) are not designed to return values or references based on X and Y coordinates.

Which of the Following Functions Returns a Value or the Reference