Apologies if this is a duplicate post. Not sure if the first one went
through.

Here's a simple example.
In column G starting row1 enter
[Select One]
France
Germany
Mexico
USA

In column G starting row 1 enter
N/A
2
2
1
1

In cell A1, create a data validation drop down. From the menu, Data
Validation List and then type in or select range G1:G5 as the
validation list. Select OK to finish this out. In cell one, choose
"[Select One]" from the drop down.

In cell B1, enter =VLOOKUP(A1,$G$1:$H$5,2,False). Which means, find
the value in cell A1 by searching vertically in the first column of
range G1:H5. When found, pull the corresponding value in the second
column. False means it must find an exact match.

Hope that helps.

- John Michl
www.JohnMichl.com