+ Reply to Thread
Results 1 to 3 of 3

Match data across multiple worksheets - Fill new column with exsisting Information.

  1. #1
    Registered User
    Join Date
    03-15-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Match data across multiple worksheets - Fill new column with exsisting Information.

    I have two worksheets, both worksheets are over 250 rows long, below I've included just a sample of what I need.

    The first worksheet includes a list of sales data that I got from my internal system. The second worksheet I have needs the sales data from the first worksheet input into the sales column to match the state and county.

    Below is an example of the first list of data that I have. As you can see Adams county is in OH, WI, IN, & IL. I need the Sales from this first list of data (also it's own worksheet>)

    State County Sales
    OH ADAMS $156.31
    WI ADAMS $1,169.28
    IN ADAMS $1,150.71
    IL ADAMS $28.90
    IL ALEXANDER $12.95
    MI ALLEGAN $734.77
    OH ALLEN $1,851.70
    IN ALLEN $7,577.15


    I need the sales data from above to be inserted into a sales column below (this would be worksheet B) also worksheet B's list is actually over 600 rows long. The information below is for sales contacts. For example we have John, David, and Sue in "Adams County, Indiana". I am putting together a mail merge letter that I need to include sales data (the blank row that needs to be filled in). I don't have time to do this manually, so any help is appreciated!!

    State County Sales
    OH ADAMS
    OH ADAMS
    OH ADAMS
    WI ADAMS
    WI ADAMS
    IN ADAMS
    IN ADAMS
    IN ADAMS
    IL ADAMS
    IL ADAMS
    IL ADAMS
    IL ADAMS
    IL ADAMS
    IL ALEXANDER
    IL ALEXANDER
    IL ALEXANDER
    MI ALLEGAN
    MI ALLEGAN
    MI ALLEGAN
    OH ALLEN
    OH ALLEN
    OH ALLEN
    OH ALLEN
    OH ALLEN
    IN ALLEN
    IN ALLEN

    Below is what the end result should look like, but I don't want to copy and paste manually.

    State County Sales
    OH ADAMS $156.31
    OH ADAMS $156.31
    OH ADAMS $156.31
    WI ADAMS $1,169.28
    WI ADAMS $1,169.28
    IN ADAMS $1,150.71
    IN ADAMS $1,150.71
    IN ADAMS $1,150.71
    IL ADAMS $28.90
    IL ADAMS $28.90
    IL ADAMS $28.90
    IL ADAMS $28.90
    IL ADAMS $28.90
    IL ALEXANDER $12.95
    IL ALEXANDER $12.95
    IL ALEXANDER $12.95
    MI ALLEGAN $734.77
    MI ALLEGAN $734.77
    MI ALLEGAN $734.77
    OH ALLEN $1,851.70
    OH ALLEN $1,851.70
    OH ALLEN $1,851.70
    OH ALLEN $1,851.70
    OH ALLEN $1,851.70
    IN ALLEN $7,577.15
    IN ALLEN $7,577.15
    Last edited by BnielsenALP; 03-15-2013 at 01:20 PM. Reason: Including end result table of what data I want filled in using formula or other shortcut.

  2. #2
    Valued Forum Contributor Harribone's Avatar
    Join Date
    02-24-2013
    Location
    Midlands, UK
    MS-Off Ver
    Excel 2019/365
    Posts
    570

    Re: Match data across multiple worksheets - Fill new column with exsisting Information.

    Solution.xlsx

    See attached which does this.
    Say thanks, click *

  3. #3
    Registered User
    Join Date
    03-15-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Match data across multiple worksheets - Fill new column with exsisting Information.

    I reviewed your solution Harribone, but it's not what I'm looking for. I revised my original post to include a table of what the end result should look like. I'm working with two worksheets. I want the sales data from my first worksheet to fill in according to the State and County data in the second worksheet.

    Thanks for your help!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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