On a separate worksheet I have a vlookup table that has columns like these:
1 United States
I've seen examples that show how to display the drop down and see the country names themselves, but I would like to know how to insert the CountryID instead of the CountryName in the cell. So when a user clicks the dropdown on the cell, they will see the country names listed, but when they select "United States" the CountryID of "1" is added to the column.
Is this possible? Are there any exampels of this anywhere?