Not possible using VLOOKUP, try
=CELL("address",INDEX(A3:D20,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,A3:D20,4,False)) However, I
get an error when I execute the function. Any suggestions?
|