Categorize data by words

Hi!

I need to categorize the country by its continent.

For example, if I key in Singapore, it must tell me that its in Asia.
If i key in Congo, it must tell me its in Africa.
If I key in Finland, it must tell me its in Finland.

Do I need to create a full list of countries and its continents like what I do below?

AFRICA:
Algeria
Angola
Benin
Botswana
Burkina
Burundi
Cameroon
Cape Verde
Central African Republic
Chad
...

ASIA:
Afghanistan
Bahrain
Bangladesh
Bhutan
Brunei
Burma (Myanmar)
Cambodia
China
...

Europe:
Albania
Andorra
Armenia
Austria
Azerbaijan
Belarus
Belgium
...

etc

What should I do next?


Can anyone help me with this please?

I see.

Is it possible that when i key in a country's name, the respective continent name will also come out beside it?

Do I need pivot table/ vba to do this?

I am an amateur excel user and I have never done such things before.

Anyway, sorry if Im asking alot of questions that may seem stupid to you!

Ohhh.

Sorry. Actually I wanted to attach my excel but I couldnt find the right button.

Hope this picture can explain things abit better.

I have this table in my excel sheet. (refer to picture, column A and B)

In the future, I hope that if i type in a country's name in an empty cell, the continent name will also appear, like F6 and F7.

Untitled.png

Like this ...

Or if you use the question in an other sheet

=INDEX(Sheet4!A:A,MATCH($A2,Sheet4!$B:$B,0),1)
and you can copy the formula to right and down for new values for that country, or values for an other country

See the file

Thank you so much!!!!!!!

Thank you so much!!!!!

Thank you so much!!!!!!!!!!!!