I'm working on a spreadsheet that will hopefully pull pricing information from a different spreadsheet, based on which customer number has been entered. I've uploaded an example to play around with. Price Fetcher COPY.xlsx
Enter a customer number (found in Sheet 2) in B1 to pull up the customer information, then enter a product code (found in sheet 3) in A10 to bring up the product information.
As each customer has it's own price list, I'm looking for a formula for cells J10 to Q10 that will look at which customer has been selected in B1, then find the information in a separate spreadsheet. I like to think I'm pretty competent with VLOOKUP and Index/Match formulas to find information, but I'm stuck with this one.
I'd like to avoid using VBA or macros if at all possible, so any help with formulas is much appreciated.
Thanks in advance,
Dom
Bookmarks