Lookup using Filename

[rascough]

Hi All,

I have some product specification sheets in single excel files named product123.xls and I now have over 60 files

What I am trying to do is create a general register file that is used to populate 1 template, for instance using a dropdown box to select product and it fills in the template. That is easy once I have the info in a table.

How could I do a lookup into say product123.xls and return the results of cell B1, b2 etc into the table and then do the same for product 124.xls and so on.

I have a list of all the product names - Can I use that to select filenames.

Any ideas
Richard

 

[ravishankar]

Hi
Yes it is possible. You have to specify which are the cells you want pulled (B1,B2 etc....)
Ravi

 

[rascough]

Any ideas where to start?

It would be various cells which would be the same in everyfile (the same template us used for all)

If I had the product name in A1 (which would be the filename without .xls)
How would i look up the contents of A1.xls (AI replced with filename) and find the contents of B1, B2 within that file