getting a cell address from a VLOOKUP

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

I am hoping someone can understand this question...

I have a worksheet with several columns and rows of
data. What I need to do is take one cell at a time in
column B and do a VLOOKUP in column D and find the same
value. That much I have figured out but what I can't
seem to do is then in the next column over, I want it to
give me the cell address instead of the value. Does
anyone know how to tell it to give me the cell address in
addition to doing the VLOOKUP?

Thanks!!
Rebecca
 
Hi,
If I have your question right,
In C1:D20 is the VLOOKUP table
In A1 is the VLOOKUP value
In A2 =VLOOKUP(A1,C1:D20,2,FALSE) to return the lookup value for A1
In B2 =ADDRESS(MATCH(A2,D1:D20),4) gives the cell address of the lookup
value for A1,
The 4 at the end of the formula being column 4, ie column D
HTH
Regards, Alan.
 
You probably would want something like

=CELL("address",INDEX($E$2:$E$100,MATCH(B2,$D$2:$D$100,0)))

where if possible a vlookup would be =vlookup(B2,D2:E100,2,0)
 
Back
Top