Auto-Assign Contact based on Country

Stephanie Bauder

I am trying to create a formula that will auto-assign the [BG Check Phase Assigned to] contact list column with an individuals name based on what country is selected from the [Country - Site] drop-down field.

So if the Country is one of:

Austria

Belgium - Brussels

Belgium - Greenhill

Belgium - Mechelen

Bulgaria

Croatia

Czech Republic

Denmark

Egypt

Estonia

Finland

France - Paris

France - Porcheville

France - Rueil-Malmaison

Germany - Bad Homburg

Germany - Cologne

Germany - Munich

Germany - Munster

Germany - Schwalbach

Greece

Hungary

Ireland - Dublin

Israel

Italy - Milan

Italy - Rome

Latvia

Lithuania

Norway

Poland

Portugal

Romania

Russia - Moscow

Russia - St Petersburg

Serbia

Slovakia

Slovenia

South Africa - Cape Town

South Africa - Centurion

Spain - Madrid

Sweden

Switzerland - Fullinsdorf

Switzerland - Geneva

Switzerland - Zollikon

Netherlands

Turkey

UK - Alnwick

UK - Eye

UK - Edinburgh

UK - Harrogate

UK - Huntingdon

UK - Leeds

UK - London

UK - Maidenhead

UK - Shardlow

UK - Slough, England

UK - York

Ukraine

THEN the BG Check Assigned to contact list field would return XXX name.

Are you able to assist with a formula?

Andrée Starå

Hi Stephanie,

Happy to assist!

I’d recommend using a combination of INDEX/MATCH.

Do you want everything on the same sheet or do you want to have the country reference on a separate sheet?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD