Which of the following functions do you often use with the INDEX function to find data from a specified row and column of data?
A) MATCH
B) OR
C) HLOOKUP
D) RANGE

Question

Quizplus · Accepted Answer

The MATCH function is often used with the INDEX function to find data from a specified row and column of data. It is used to return the position of a lookup value in a specified array or range, which can be then be used as the row or column number input in the INDEX function.

Which of the Following Functions Do You Often Use with the INDEX