Return a Cell Value by Row and Column Number in Excel
Question details
Find a value in a two-dimensional Excel range using a row number and a column number.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user wants a formula that returns the value at a specified row and column within a range.
- Observed behavior
- The formula should return the value at the intersection of the specified row and column.
Identify the range to search and count the target row and column from the range's top-left cell. If you plan to use cell references for the numbers, enter them outside the search range.
Use INDEX with row and column numbers in Excel
Use this formula to return a value at a specific position in a two-dimensional range.
In your Excel worksheet, click an empty cell where you want the result to appear.
Type =INDEX(A1:G10,3,4) and press Enter. This returns the value in the third row and fourth column of A1:G10, which is cell D3.
To make the position adjustable, enter a row number in H1 and a column number in I1, then enter =INDEX(A1:G10,H1,I1) in the result cell.

Return a Value by Row and Column in WPS Spreadsheets
Use the INDEX function in WPS Spreadsheets to retrieve a value from a range by its row and column position.
- 1. Open your workbook: Launch WPS Spreadsheets and open the workbook containing your data.
- 2. Select a result cell: Click an empty cell outside the range you want to search.
- 3. Enter the formula: Type =INDEX(A1:G10,3,4) and press Enter to return the value from D3.
- 4. Make the lookup adjustable: Optionally, enter the row number in H1 and the column number in I1, then use =INDEX(A1:G10,H1,I1) in the result cell.

Frequently Asked Questions
How do I return the value in D3 using INDEX?
Enter =INDEX(A1:G10,3,4) in an empty cell. D3 is the third row and fourth column of that range.
Can I put the row and column numbers in separate cells?
Yes. Enter the row number in H1 and the column number in I1, then use =INDEX(A1:G10,H1,I1).
Why does INDEX return a #REF! error?
Check whether the row or column number exceeds the dimensions of the selected range. For A1:G10, valid positive row numbers are 1–10 and column numbers are 1–7.
Are INDEX row and column numbers based on the worksheet or the selected range?
They are based on the selected range. For example, =INDEX(B2:G10,1,1) returns the value in B2.




