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
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