address of a cell

  • Thread starter Thread starter JOHN
  • Start date Start date
J

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
 
Use cell index and match, assume you vlookup looks something like this

=VLOOKUP(A1,C2:D100,2,FALSE)

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

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

=CELL("address",INDEX(D2:D100,MATCH(A1,C2:C100,2,0)))
 
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
 
Back
Top