I receive an excel data dump which contains about 10,000+ of domains in it.
I have a separate list which is in excel (although I could format it in any way) containing about 100 domains.
I need to be able to search the large file and extract only the data pertaining to the 100 domains I have.
Where do I start? Because I receive these data dumps regularly I need something that is repeatable and relatively straight forward to execute.