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