email country

Question

Hi,&nbsp;&nbsp;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?&nbsp;&nbsp;The two columns are beside each other. Please respond asap.&nbsp;&nbsp;

oliverscheurich · Answer

barrylenahan&nbsp;=VLOOKUP(RIGHT(A3,2),$D$3:$E$7,2,FALSE)Maybe with&nbsp;VLOOKUP. Otherwise can you attach a screenshot without sensitive data with an example of your expected result?

hansvogelaar · Answer

barrylenahan&nbsp;
Perhaps as in the attached demo workbook?
Source: Country code top-level domain&nbsp;

barrylenahan · Answer

Hi,&nbsp;&nbsp;Thanks sorted out the formula.&nbsp;=IF(COUNTIF(A7,"*.ie*"),"Ireland","United Kingdom")&nbsp;&nbsp;barrylenahan&nbsp;

Forum Discussion

email country

Share

Resources