You can use a formula and index/match
Assume your vlookup would look like this

=VLOOKUP(A1,MyTable,2,0)

the equivalent would be

=INDEX(MyTable,MATCH(A1,INDEX(MyTable,,1),0),2)

where 2 is the index column responding to the 2 in the vlookup and 0 = FALSE

then this would return the address

=CELL("address",INDEX(MyTable,MATCH(A1,INDEX(MyTab le,,1),0),2))



--

Regards,

Peo Sjoblom

"CR_2004_04_08" wrote in message
...
Is there a way to get this value?

my vlookup function returns a value from a row that has
additional detail. I would like to to retrieve the cell
address associated with the returned value from vlookup.
Is this possible?