Multi Column Match

[mallieteal21]

I have two data sets - one with a list of all the names I am looking for (Sheet LookingFor) and the other contains a list of file paths (sheet ALLDWG). I'm trying to match the names in LookingFor to the file paths in ALLDWG to see how many file paths contain those names. Ultimately I want to match each line item on the looking for sheet to the list of file paths on the ALLDWG sheet. Can anyone the best approach? I started to parse the text but not sure that is the best method. I've also attached a copy of what I want the final results to look like - these were gathered manually in excel. Any help is greatly appreciated! 

[CoG · Accepted solution]

Here's a Batch Macro that I believe accomplishes you're stated goal.

Just be aware that it can take some time to run (~30 seconds on my machine with provided data) due to the large number of comparisons required.

[mallieteal21]

Thank you so much!! This is exactly what I needed.