Sep 16 2022 04:47 AM
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.
Sep 16 2022 04:55 AM
=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?
Sep 16 2022 04:59 AM
Sep 16 2022 05:11 AM
Hi,
Thanks sorted out the formula. =IF(COUNTIF(A7,"*.ie*"),"Ireland","United Kingdom")