You could nest several Index functions to do this.

First, establish the row of the desired value in column A with these two Index functions:

```
=INDEX(A:A,MATCH(FindIndex,A:A,0)):INDEX(Z:Z,MATCH(FindIndex,A:A,0))
```

The `FindIndex`

is a named cell (C7) that has the value you want to find in column A. If you have 70 columns of data, you need to adjust the `Z:Z`

to be the last column of your data.

Now you can use this range inside another Index/Match combo, where it serves as the range for Index, and again as the range for Match. In the Match part, the `findData`

is a range name for a cell (C8) that holds the "data3" value. Match finds that cell by adding 1 to the result, you can return the next cell over.

```
=INDEX(
INDEX(A:A,MATCH(FindIndex,A:A,0)):INDEX(Z:Z,MATCH(FindIndex,A:A,0)),
MATCH(findData,INDEX(A:A,MATCH(FindIndex,A:A,0)):INDEX(Z:Z,MATCH(FindIndex,A:A,0)),0)+1)
```

`OFFSET()`

too? Or`Index/Match`

? – BruceWayne May 12 '17 at 20:30