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

On Jan 17, 10:28*pm, KJ wrote:
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?