email country

[barrylenahan]

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.  

[#2]

@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?

[#3]

@barrylenahan 

Perhaps as in the attached demo workbook?

Source: Country code top-level domain 

[#4]

Hi, 

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

@barrylenahan