Compare 2 worksheets

[Closed]
Report
Posts
1
Registration date
Saturday July 10, 2010
Status
Member
Last seen
July 10, 2010
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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