Retrieving Values from another Excel Workbook Using Text References

Problem:

Listed in column A are the path, file name, sheet name, and cell reference for a range containing pairs of numbers and letters.
We want to lookup each of the numbers in column C in the range specified in column A and retrieve the matching letters.

Solution:

To retrieve the values listed in column C in the range specified in column A, use the VLOOKUP and INDIRECT function as shown in the following formula:
=VLOOKUP(C2,INDIRECT("'"&$A$2&"\["&$A$5&".xls]"&$A$8&"'!"&$A$11),2,FALSE)

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.