retreiving cell address of vlookup value
 

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


--
amyc
------------------------------------------------------------------------
amyc's Profile: http://www.excelforum.com/member.php...o&userid=35192
View this thread: http://www.excelforum.com/showthread...hreadid=549604

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

retreiving cell address of vlookup value
 

Both formulas work perfectly!


--
amyc
------------------------------------------------------------------------
amyc's Profile: http://www.excelforum.com/member.php...o&userid=35192
View this thread: http://www.excelforum.com/showthread...hreadid=549604