Lookup using Filename

rascough

New Member
Joined
Oct 22, 2003
Messages
13
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
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

ravishankar

Well-known Member
Joined
Feb 23, 2006
Messages
3,566
Hi
Yes it is possible. You have to specify which are the cells you want pulled (B1,B2 etc....)
Ravi
 

rascough

New Member
Joined
Oct 22, 2003
Messages
13
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
 

Forum statistics

Threads
1,181,648
Messages
5,931,213
Members
436,784
Latest member
amuljono

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top