Depending on the size of your actual files, it might also be a good candidate for a batch macro. You could loop through the values in the Invoice list one at a time and compare them to the master individually that way.
Thank you so much very helpful. But is it possible to get the match score. The one's i marked in Yellow and Red are almost same. So we need to identify those as well. For eg. "Noal lime limited" and "Noal lime limited companies " are almost same except one extra word "companies" . Can we capture these?
Also you mentioned about batch macro. Can you please share some link or thoughts how to go about this as well?
In that case, you could use the Fuzzy Match tool, which will give you the match score. There are a few options for setting that tool up, so definitely check out the help page. But that tool will allow you to find an acceptable threshold for "close enough" matches.