email country

New Contributor

Hi, 

 

I am trying to add countries to coincide with emails for example joebloggs.ie and ireland on an excel format. Would someone know the correct format for this? 

 

The two columns are beside each other. Please respond asap.  

3 Replies

@barrylenahan 

=VLOOKUP(RIGHT(A3,2),$D$3:$E$7,2,FALSE)

Maybe with VLOOKUP. Otherwise can you attach a screenshot without sensitive data with an example of your expected result?

email country.JPG

@barrylenahan 

Perhaps as in the attached demo workbook?

Source: Country code top-level domain 

Hi, 

 

Thanks sorted out the formula. =IF(COUNTIF(A7,"*.ie*"),"Ireland","United Kingdom")

 

 

@barrylenahan