# How to return the cell below a matching value in Excel

Find the label with MATCH and add one row: `=INDEX(A2:A11,MATCH(D1,A2:A11,0)+1)`.

**Excel:** `=INDEX(A2:A11,MATCH(D1,A2:A11,0)+1)` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C | D |
| --- | --- | --- | --- |
| Report export |  | Field | Total |
| Invoice number |  | Value |  |
| INV-2041 |  |  |  |
| Customer |  |  |  |
| Contoso Ltd |  |  |  |
| Total |  |  |  |
| 1250 |  |  |  |
| Due date |  |  |  |
| 2026-07-15 |  |  |  |
| Status |  |  |  |
| Unpaid |  |  |  |

Formula in D2: `=INDEX(A2:A11,MATCH(D1,A2:A11,0)+1)`

Result: 1250

## How it works

MATCH finds "Total" at position 5 of `A2:A11`. Adding 1 points at the next cell, and INDEX returns position 6, the 1,250 below the label. Any offset works the same way: +2 for two rows down, −1 for the row above.

## Other ways

- `=XLOOKUP(D1,A2:A10,A3:A11)`: Search one range and return the same range shifted down a row: the cell beside each label in the return range is the one below it on the sheet.

## Common mistakes

- If a value could equal a label (a customer named "Status"), MATCH finds that cell first. Search only label rows if the layout allows.
- A label in the last row has nothing below it, and INDEX returns #REF!.

## Questions

**How do I return the cell to the right of a match instead?**

Use a two-column range and column 2, or XLOOKUP with the next column: `=XLOOKUP(D1,A2:A11,B2:B11)`.

**How do I turn the whole export into two columns?**

In Excel 2024 or Microsoft 365, `=WRAPROWS(A2:A11,2)` pairs each label with its value.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/value-below-a-match