How do I get the cell address of the location where a VLOOKUP match has occurred?
B beetle Oct 10, 2004 #1 How do I get the cell address of the location where a VLOOKUP match has occurred?
J Jason Morin Oct 10, 2004 #2 =VLOOKUP(A1,E:F,2,0) will return a value. The cell address of that value is: =CELL("address",INDEX(F:F,MATCH(A1,E:E,0))) HTH Jason Atlanta, GA
=VLOOKUP(A1,E:F,2,0) will return a value. The cell address of that value is: =CELL("address",INDEX(F:F,MATCH(A1,E:E,0))) HTH Jason Atlanta, GA
