Odd Excel Bug

[rabso]

Good afternoon, I have a formaul that gives me the cell address of a vlookup query. How ever sometimes it gives me a default E1. Although that is A) Not the cell, and B) the vlookup exists.

=CELL("Address",INDEX($E:$E,MATCH(CD3,$E:$E,1)))

Any ideas?

Cheers
Richie

 

[RoryA]

What are you looking up and is your list sorted?
You could also use:
="E"&MATCH(CD3,$E:$E,1)
or if you want exact matching use:
="E"&MATCH(CD3,$E:$E,0)

 

[rabso]

Hi Rory,
I have a data table at the start of that worksheet, and I need to be able to retrieve the row.
I have used your second option and that has worked.
Thank you.