Results 1 to 3 of 3

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

Threaded View

  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.

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