Return the cell at a specific row and column position within a range.
Copy this formula
=INDEX(Data, 3, 2)INDEX(range, row_num, col_num) returns the value at that intersection — counting from the top-left of the range, not the sheet. Combine with MATCH to make the positions dynamic.
=INDEX(A1:D100, 10, 3)→Item CRow 10, column 3 of the range.
Yes — set the row or column argument to 0 to return the entire column or row as an array.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.