Which function will return the intersection of a specific row and column?
A)VLOOKUP
B)HLOOKUP
C)INDEX
D)MATCH

Question

Quizplus · Accepted Answer

The INDEX function returns the value at the intersection of a specific row and column. You just need to provide the array or range, and the row and column numbers to specify the position of the value you want to retrieve.

Option A (VLOOKUP) and option B (HLOOKUP) are not ideal choices, as they are designed to retrieve data from a specific column or row based on a match with a lookup value. Option D (MATCH) is also not the best choice, as it only returns the position of the specified value within a range or array, rather than the value itself.

Which Function Will Return the Intersection of a Specific Row