i made a second sheet from the previous list of countries. in order to create a proper dropdown menu, i used the xlookup feature.