Thread: Finding a Workbook based on a Cell information in another Workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default Finding a Workbook based on a Cell information in another Workbook
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/300...-10423159.html and then use the
INDIRECT.EXT function.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Walter" wrote in message
...
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.

Reply With QuoteReply With Quote