2 lists that need to be checked against 2 other lists
List A is entity names - Column A
List B is individual names - Column C
List C is a huge list(more than 6k) of names Column F
List D is a huge list(more than 6k) of alternate names - Column I
All lists are in alphabetical order
List A and B need each name checked to see if they exist on list C or D
If any of the names in List A or B appear on list C or D, they need to be flagged in some way, an entry created in the next column, or copied to another sheet. The names from list A or B that appear on list C or D can either be an exact match, or contain the name.
The lists are almost completely letters, but there are a few random numbers
I currently have all 4 lists on one sheet
Please let me know if you need more information.
Also, I'd like to be able to add to lists A and B at any time. The 4 lists get updated weekly, so this needs to be a spreadsheet I can maintain.
List A is entity names - Column A
List B is individual names - Column C
List C is a huge list(more than 6k) of names Column F
List D is a huge list(more than 6k) of alternate names - Column I
All lists are in alphabetical order
List A and B need each name checked to see if they exist on list C or D
If any of the names in List A or B appear on list C or D, they need to be flagged in some way, an entry created in the next column, or copied to another sheet. The names from list A or B that appear on list C or D can either be an exact match, or contain the name.
The lists are almost completely letters, but there are a few random numbers
I currently have all 4 lists on one sheet
Please let me know if you need more information.
Also, I'd like to be able to add to lists A and B at any time. The 4 lists get updated weekly, so this needs to be a spreadsheet I can maintain.