address of a cell

[JOHN]

I am getting a value by using a vlookup.
what do I need to do to get the address of the cell that I
found with vlookup?

thanks

 

[Peo Sjoblom]

Use cell index and match, assume you vlookup looks something like this

=VLOOKUP(A1,C2100,2,FALSE)

=INDEX(D2100,MATCH(A1,C2:C100,2,0))

would be the equivalent, now put it in the cell function

=CELL("address",INDEX(D2100,MATCH(A1,C2:C100,2,0)))

 

[CLR]

Peo.......

I tried to respond to you about this post via a private email but it got
kicked back to me as follows:

----- Transcript of session follows -----
<[email protected]>... Deferred: Connection refused by mvp.org.
Message could not be delivered for 1 day
Message will be deleted from queue

Did you know this was happening?

Vaya con Dios,
Chuck, CABGx3

 

[Peo Sjoblom]

Charles,

you forgot an

(e-mail address removed)