I have 2 datatables containing names that needs to be looked up. 1 Excel file containing around 250 unique names, and another Excel file containing around 20,000 names, where there are duplicates.
What I want to know is if there is a way to use a for each row in the first excel file with 250 names, and go through each name and see if there are any duplicates in the second Excel file and how many. If there are, write the name and amount of strings are in that Excel file, in a separate file.
I feel like this should be doable with LookUp range and an If statement but I am not sure how to make everything work together.
Appreciate all the help so I can learn!