I think it may help if I showed the formula I have been trying to use. Need
Help.

I need a formula that would allow me to enter a the names of multiple
countries into a column and have it automatically placed into another column
by continent. For example:

If: Then:

A1 is United States B1 should be North America
A2 is Mexico B2 should be North America
A3 is France B3 should be Europe
A4 is Germany B4 should be Europe
A5 is Japan B5 should be Asia

So, if A1:A5 is United States, then B1:B5 should automatically be North
America.

Here is the formula I have been trying to work with

=SUBSTITUTE(D103:D164,"Germany,Spain,France","Euro pe")

Can someone help. Thanks.