Need Help with merging/sorting multiple worksheets

Ok so I have three different excel sheets that are all formatted like below, but are for different years. I want to merge the accounts, agency, AE columns, and have it put the dollar amounts for the different years in separate columns. Can this be done?



Account___________________ Agency__________________________ AE_____________2012
131auction.com_____________ Bottom Line Advertising________ Pathuis, Sandy______ $403
20th Century Market____________________________________ Oakwood, Mike_____ $250
29th Street Antique Mall_______ Pam Spring Advertising_______ Velzen, Cheryl______ $1,192



Account__________________________ Agency____________________ AE_________ 2011
131auction.com____________Bottom Line Advertising__________ Pathuis, Sandy_____ $510
20th Century Market_____________________________________ Oakwood, Mike_____ $2,130
28 Street West________________________________________ All Stations, House $1,100
29th Street Antique Mal_____Pam Spring Advertising___________ Velzen, Cheryl______ $2,493


So in the end it would look like...


Account____________________ Agency___________________________AE__________ 2011____ 2012
131auction.com_____________ Bottom Line Advertising________ Pathuis, Sandy______ $510____$403
20th Century Market____________________________________ Oakwood, Mike_____$2130___$250
28 Street West_________________________________________ All Stations, House___$1,100___ $0
29th Street Antique Mall_______ Pam Spring Advertising________ Velzen, Cheryl______ $2493____$1,192

If your accounts are unique, then in probably your 2011 sheet itself, use in the column next to teh 2011 dollar amount
=IFerror(vlookup(A1,2012!A:C,3,False),0) and drag down

Does this help?

I think you get better help if you put your data in an excel example, without confidentional information.

I should solve it with an pivot table. (see sheet 1)