View Single Post
  #3   Report Post  
Old May 16th 05, 06:35 PM
Peo Sjoblom
 
Posts: n/a
Default

Not possible using VLOOKUP, try

=CELL("address",INDEX(A320,MATCH(A2,A3:A20,0),4) )


Regards,

Peo Sjoblom


"Spock" wrote:

I'm trying to obtain the address of a cell using the Cell Function and the
Vlookup function. i.e. =Cell("address",vlookup(A2,A320,4,False)) However, I
get an error when I execute the function. Any suggestions?