A
amyc
Anyone know what the easiest way is to get the cell address of th
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 B
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 B