Look up values in a single column

[Vegas01]

Hi everyone, I have a problem that I can't get my head around, I am trying to look up a value, and all of the data is in the same column, the return value is one cell underneath the lookup value.

For Example

I have 3000 lines of data on line 994 is the lookup reference "Rental" and on line 995 is the return value of 1,000 I need. I can't work it out.

Rental
1,000

Thanks In advance
Nikki

 

[Michael M]

Assuming the data is in Column "A"
Use

=INDEX(A1:A3000,MATCH("Rental",A1:A3000,0)+1,1)

 

[Vegas01]

Michael Cool, I was missing the +1

 

[Michael M]

Glad to help...

 

[Peter_SSs]

Not suggesting that you should, but you could do it without the +1 like this.

=INDEX(A2:A3000,MATCH("Rental",A1:A2999,0))