MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Comparing 2 spreadsheets


Posted by Quang Tran on September 06, 2001 11:25 AM

Thanks in advance for any assistance.
Let's say I have 2 separate spreadsheets. Spreadsheet A has these columns: Customer ID, August sales. Spreadsheet B has: Customer ID, Sept sales. I would like to quickly compare the two sheets by Customer ID. For example, line up Spreadsheet A!Customer ID with Spreadsheet B!Customer ID and have August sales and September sales on the same row.
(What I do now is use MS Access to accomplish this very same task.)


Posted by Barrie Davidson on September 06, 2001 11:46 AM

Quang, could you use a master customer list and then use a vertical lookup on your August and September sales?

Barrie

Posted by Quang Tran on September 06, 2001 12:08 PM

>> Ok, let's go with that idea. How do I use vertical lookup? Thanks.

Posted by Barrie Davidson on September 06, 2001 12:11 PM

Have a look at
http://ca.geocities.com/b_davidso/Web_Page_Files/Excel/lookup.html

If you need any further explanation just let me know.

Regards,
BarrieBarrie Davidson