What does the INDEX function return in Excel?

Question

Microsoft Excel — Medium

What does the INDEX function return in Excel?

Accepted Answer

The INDEX function returns a value based on its position within a range. It looks up a value at the intersection of a specified row and column, making option B the correct answer. Options A, C, and D are incorrect as they describe unrelated functions, such as finding a value's position or identifying data types.