A formula that would suit what you're looking for would be this:

```
=OFFSET(E2,MATCH(0,E:E,0)-3,0)
```

`E2`

is the first value in column 5 (48)

`OFFSET`

with the cell at the beginning of the column and moves down by `MATCH(0,E:E,0)-3`

.

`MATCH(0,E:E,0)`

will return the row in which it can find the first occurrence of `0`

(The parameters are: look for `0`

into column `E:E`

and use `0`

to mean exact match).

The `-3`

is to account for the header, the first cell and move up one cell because `MATCH`

will return the position of `0`

, not the one of the cell just above it.

The last parameter in `OFFSET`

is by how many columns the range should move, and since we're already in column E, there's no movement in this respect.

EDIT: Since the column `Year`

are perfect zeroes (the column 5 contains very small numbers rounded to 1), you can use this instead:

```
=OFFSET(E2,MATCH(0,A:A,0)-3,0)
```

## Understanding OFFSET

Say you use the formula:

```
=OFFSET(A1, 1, 1)
```

`OFFSET`

will return the cell which is found 1 row below and 1 column after the cell `A1`

, meaning cell `B2`

.

Similarly, `=OFFSET(A1, 3, 1)`

will give the cell `B4`

.

There are actually more options you can have in `OFFSET`

, namely the height and the width of the resulting range.

```
=OFFSET(A1, 1, 1, 2, 3)
```

`OFFSET`

will return the cell which is found 1 row below and 1 column after the cell `A1`

, meaning cell `B2`

. Then, the height of the result will be 2, and the width 3, meaning it would return the range `B2:D3`

(if you select this range with your mouse, you see it'll be 2 cells high and 3 cells wide). However, since this is an array, you will get an `#N/A`

with this formula. You can still carry out operations with this array, such as `VLOOKUP`

or `INDEX`

, `SUM`

, etc.