VLOOKUP - Compare Customers in 2 Sheets
Posted by Mike M on June 12, 2001 5:12 PM
I am a novice so hopefully you can help me.
I get a weekly spreadsheet which has about 8 pages of customers each week. It is very inefficient to try and figure out what has been added or deleted. Someone suggested that I use vlookup, but the directions in the Excel don't seem to be that intuitive.
Let's say one spreadsheet is called June1.xls and the new one is June8.xls. The Customer names are contained in column C. Here is where it gets fuzzy. How do I compare the Customer names in the new spreadsheet versus the older spreadsheet to show where the customer is new? This should be simple but so I am. Please help. Thanks.