+ Reply to Thread
Results 1 to 4 of 4

Find Information from Multiple Spreadsheets

  1. #1
    Registered User
    Join Date
    04-09-2015
    Location
    Manchester, England
    MS-Off Ver
    2010
    Posts
    39

    Find Information from Multiple Spreadsheets

    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

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Find Information from Multiple Spreadsheets

    I'm not sure if I'm missing something obvious, but from where are columns J:Q supposed to be populated from?
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  3. #3
    Registered User
    Join Date
    04-09-2015
    Location
    Manchester, England
    MS-Off Ver
    2010
    Posts
    39

    Re: Find Information from Multiple Spreadsheets

    Quote Originally Posted by mcmahobt View Post
    I'm not sure if I'm missing something obvious, but from where are columns J:Q supposed to be populated from?
    There are individual price lists for each customer, on separate Excel documents - I didn't upload an example as the information itself is irrelevant. I'm looking for a formula that will check which customer has been entered, and bring up the necessary price list.

    Hope this helps!

  4. #4
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Find Information from Multiple Spreadsheets

    I'm not sure what you're after then. It seems like you already are able to pull the price list for a customer based on B3 from your Sheet1. Where is this Price List you referenced?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Grabbing multiple information from columns from multiple spreadsheets
    By MichaelHopkins in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2015, 05:11 PM
  2. Formula to Find Information from Multiple Spreadsheets
    By DomSza in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-09-2015, 11:03 AM
  3. Duplicate information across multiple spreadsheets that are amalgamated?
    By Garion in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2015, 04:38 AM
  4. Replies: 5
    Last Post: 11-02-2012, 03:08 AM
  5. Replies: 4
    Last Post: 03-01-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1