retreiving cell address of vlookup value
Try...
=CELL("address",INDEX(B10:B12,MATCH(A1,A10:A12,0)) )
or
=CELL("address",INDEX(A10:B12,MATCH(A1,A10:A12,0), 2))
Hope this helps!
In article ,
amyc wrote:
Anyone know what the easiest way is to get the cell address of the
result of a vlookup function?
Example:
Col A Col B
Row 1 CA ???
Row 10 AZ Arizona
Row 11 CA California
Row 12 IL Illinois
vlookup(A1, A10:B12, 2, false) = California
= I want the cell address of "California" to appear in B1
|