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
Bookmarks