Hi everyone,



I am new here so please allow me to greet you, the kind future helper and current reader. I am trying to create a formula that would check values in column with country codes, compare it to a list of valid country codes and if it finds one, check another column with full country names and compare it to a list of valid country names. In essence what my task comes down to is that I have a very long list of records with user account details and need to validate if all of them have country code assigned and if it matches the country name to remove users with missing or incorrect data. My approach to this task would be to create a table of all country codes and country names and perhaps use vlookup or if function to browse through the user list. I will higly appreciate your help with this task.

Thank you very, very much (in advance, but will surely thank afterwards as well),

Jan