Hello,
I need a formula that will replace the countries in a field in Sheet1 by looking at Sheet2 and replacing the country with the corresponding Country Code.
Below is just a sample of the data.
Sheet1:
Sheet2:
Thank you,
Miriam
I need a formula that will replace the countries in a field in Sheet1 by looking at Sheet2 and replacing the country with the corresponding Country Code.
Below is just a sample of the data.
Sheet1:
| Country |
| UK |
| Singapore |
| US |
| All Costa Rica;Argentina;Bahamas;Brazil;Colombia;Costa Rica CSC;Mexico;Venezuela |
| Ireland;UK |
| Jersey;Luxembourg;Switzerland;UK |
| Canada;US |
| Algeria;All Costa Rica;Argentina;Australia;Brazil;Bulgaria;Cameroon;Canada;Colombia;Congo;Costa Rica;Czech;Dominican Republic;Ecuador;Egypt;Gabon;Guatemala;Honduras;Hong Kong;Hungary;India;Indonesia;Israel;Kazakhstan;Kenya;Mexico;Nigeria;Pakistan;Panama;Paraguay;Peru;Philippines;Puerto Rico;Qatar;Romania;Russia;Singapore;Slovakia;South Africa;Switzerland;Taiwan;Tanzania;Thailand;Trinidad & Tobago;Turkey;UAE;UK;Ukraine;Uruguay;US;Venezuela;Zambia |
| Japan |
Sheet2:
| Country | Country Coded |
| Algeria | Algeria(DZ) |
| Argentina | Argentina(AR) |
| Aruba | Aruba(AW) |
| Asia Hub | Asia Hub(X6) |
| Australia | Australia(AU) |
| Austria | Austria(AT) |
Thank you,
Miriam
