Function Problems

Return a Cell Value by Row and Column Number in Excel

Steve KSteve K Nov 18, 2026 868 views

Question details

Find a value in a two-dimensional Excel range using a row number and a column number.

Return a Cell Value by Row and Column Number in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the result cell

In your Excel worksheet, click an empty cell where you want the result to appear.

2
Enter the INDEX formula

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.

3
Use cell references if needed

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.

Use INDEX with row and column numbers in Excel
Count within the selected range: Row and column numbers are relative to the range, not necessarily the worksheet. For example, in B2:G10, row 1 and column 1 refer to B2.
WPS Spreadsheets

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. 1. Open your workbook: Launch WPS Spreadsheets and open the workbook containing your data.
  2. 2. Select a result cell: Click an empty cell outside the range you want to search.
  3. 3. Enter the formula: Type =INDEX(A1:G10,3,4) and press Enter to return the value from D3.
  4. 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.
Look up a value by row and column with INDEXOpen and edit Microsoft Excel XLSX and XLS filesUse cell references to change lookup positions without rewriting the formulaWork in a familiar spreadsheet interface
microsoft office alternative - wps office

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.