match & combine 2 zip code lists and dollar amounts

  • Thread starter Thread starter Will123
  • Start date Start date
W

Will123

I have one worksheet with a large list/column of zip codes, column of dollar
amounts and a column of counties. i have another wksheet with a shorter list
of zip codes (some duplicates & some new to the first wksheet) and a column
of dollar amounts... i want to match/combine the duplicates and new zip code
list from wksheet 2 to the wksheet 1 list and also add the corresponding
dollar amounts to the wksheet 1 list of dollar amounts when duplicates and
just add new rows of zip codes, dollar amounts when not duplicates. thanks.
 
Hi Will,

You can leave the two data sets in place and create a consolidated pivot
table, from the pivot table and pivot chart wizard. You can find the wizard
by adding it to the quick access toolbar, click on the down arrow for more
commands.

Using multiple consolidation ranges.

Since this will only allow you to have one column, you should use the zip
code for the left column and the dollar amount for the right column. The
headers for the two sets of data must be the same names.
 
Back
Top