Compare 2 worksheets

Closed
amd916 Posts 1 Registration date Saturday July 10, 2010 Status Member Last seen July 10, 2010 - Jul 10, 2010 at 08:48 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 10, 2010 at 10:03 AM
Hello,

I'm just new here and not an Excel expert. I have two Excel sheets with Names, address and other information.
Here's the thing, not all names in sheet1 are also in sheet2. This is to say that sheet2 is my complete list but just need to get the names that only match with the names in sheet1. So what I need is, match all the names in sheet1 and sheet2. Have 1 additional column in Sheet2 that will have a value of true or false if it find its match in sheet1.

Hope you can help guys.

thanks!

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jul 10, 2010 at 10:03 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
0