Reference external workbook cell value in active workbook using an identifier number

Hi everyone,

Cell A1 has an indentifier number. This identifier number corresponds to a .xls/xlsx file with the same name in C:/stuff folder. I.e. the identifer number is RRR11, the external workbook is RRR11.xlsx

What I'm trying to do is have cell C2 in the active workbook populate with the value in cell C2 of the external workbook named using the same identifier number as in cell A1 of the active workbook. The result is that I want to pull the value from a specific cell in the external workbook, say D2, and put that value in the active workbook D2 cell.

The external workbook will not be open, so I don't think INDIRECT will work. Any ideas?

Thanks everyone!!

Try INDIRECT EXT.
from MoreFunc
http://excelenthusiasts.sharepoint.c...s/Morefunc.zip

Could you post an example?

If you are trying to use referenced text to be part of a formula, then, without using VBA, INDIRECT() is pretty much the only way to do that. And, as INDIRECT() does not work on closed workbooks, Robert's suggestion is the way to go