Does anyone happen to know if there is a way to edit this formula so it would catch non-exact matches as well??
=IF(ISERROR(MATCH(A1,Sheet2!$A$1:$A$100,0)),"Unique","Duplicate")
I'm comparing two lists of companies, one list is 1200 rows, the one I'm comparing it against has over 100,000 rows. Some of the names don't completely match but still need to be flagged if they are approximate.
Example would be "Amazon.com" on one list and "Amazon.com headquarters" or "Amazon LLC" on another.
Thanks!
Bookmarks