Formula to Find Information from Multiple Spreadsheets

Good afternoon,

I'm working on a spreadsheet that should (in theory!) help me find pricing information about customers much easier.

The spreadsheet works so that when I type a Customer Account Number in cell A1 and a product code in A5, it brings up the relevant pricing information based on which customer has been entered. This would be simple enough, but the pricing information is on a separate excel document - and there are 15 separate excel documents for all the customers.

I'm quite competent with the use of VLOOKUP and Index/Match formulas to pull through the relevant information - but I'm struggling to find a formula that will search through a different Excel document for information.

I'd like to avoid VBA if at all possible, so any formula suggestions are more than welcome. If you need more information, please do not hesitate to ask.

Thanks for your help,
Dom

Price Fetcher COPY.xlsx

Above is a copy of the spreadsheet, type a customer number in B1 (info found in sheet 2)and a product code in A10 (info found in Sheet 3) to use the spreadsheet.

I'm looking for a fomula to go in cells J10:Q10 that will pull pricing information from a separate document based on which customer has been entered in B1.

Hope this helps!