Finding a Workbook based on a Cell information in another Workbook

[Walter]

In Workbook 1 I can select from a dropdown list of several workbooks that I
have. Based on what is selected, I would like to come up with a formula that
would put that info into a formula so that I can gather the information from
the second workbook.

 

[Ashish Mathur]

Hi,

The INDIRECT() function will not work in this case because of different
workbooks. You can download and install the following addin
http://www.download.com/Morefunc/3000-2077_4-10423159.html and then use the
INDIRECT.EXT function.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com