vlookup cell reference

[KJ]

What formula can I use to return a cell number that a vlookup output
references.
For instance:

Data in A1:A3 = X,Y,Z
Cell B1= X
Cell C1=vlookup(A1,A1:A3,3,false) Out put should be "Z".
I want D1 to be the cell number of "Z". I want my output to be "A3".

What am I missing?

 

[Tyro]

I suggest you look at Excel help on how to use vlookup. I presume your
fomula is =vlookup(b1,a1:a3,3,false). This formula says: lookup b1 in the
array a1:a3 and if found get the value from the 3rd column. There is no
third column. Your array is a1:a3. To have a third column, it would have to
be a1:c3. Perhaps you could enlighten us.

Tyro

 

[Pete_UK]

I don't think your examples quite tie in with each other, but have a
look at the MATCH function in XL Help - this returns the relative row
of where the match occurs, so you can build up your cell reference
from that.

Hope this helps.

Pete