Lookup & Reference

INDEX

Returns a value or reference of the cell at the intersection of a particular row and column, in a given range.

Syntax
INDEX(array, row_num, [column_num])
Usage Examples
See how this formula can be used in real-world scenarios, generated by AI.
AI Assistant

Ask me anything about Excel formulas!