I have two lists. The first has 4000 records of suppliers and the second is a separate list with over 400000 suppliers. Each supplier is identified by name only and there may be different naming conventions.
I have already done the matching where an exact match exists. I then created two further lists;
- contains the first word from the 4000 list
- contains the first 2 words from the 4000 list
Is there a quick way that I can compare these two new lists to the 400000 list where it will highlight those items in the big list that contain the words in the 2 new lists I have created?