View Single Post
Old 04-28-2013, 10:42 AM
bob999999 bob999999 is offline Windows 8 Office 2013
Join Date: Apr 2013
Posts: 1
bob999999 is on a distinguished road
Default matching names in column A with names in column C

I have a list of customers in column A and their sales in column B from 2013. I have the same data in columns C & D for 2012. Some of the customers in column A were not customers in 2012, and some of the customers in column C are not customers in 2013. I want one list that includes all customers, and produce sales for both years; if a customer bought in both years it would produce sales amounts in columns B & D; if just 2013 then only in column B and zero (or blank) in column D; if just 2012 then only in column D and zero (or blank) in column B.
I tried the LOOKUP function but it did not work; I do not know how to use the pivot tables.
Any suggestions?
Reply With Quote