View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KJ KJ is offline
external usenet poster
 
Posts: 43
Default vlookup cell reference

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?