Drop Down List in Cell

[rickdean]

I am creating a list that pulls from a datasource on a different page in the same workbook.  I am not sure how to ask the question.  Its a list of every country in the  world.  The user will need to pick the country they need.  I would like them to be able to start typing the country and it will sort through the list and bring up the closest matches depending on what has been typed. I know I have created them before but its been a LONG time.  I am using Excel 365 Enterprise.  Any guidance would be appreciated.

[#2]

@rickdean 

How to create a searchable drop down list in Excel?

Speed up data entry and validation with AutoComplete for dropdown lists in Excel for Windows

Searchable dropdown in DESKTOP

[#3]

Thank you for the information. That was extremely helpful. It works. I need to create 19 more of the exact same. I tried to copy the first drop down but it just enters the same information in all 19 drop downs. I am sure its an easy fix but I am not sure what to do.

[#4]

@rickdean 

Attached in the inserted file are two examples.

Found it while poking around in my old files, maybe it will help you make it even easier.

..if not...just ignore it:).

I hope I could help a bit, wish you a lot of fun with Excel :)

NikolinoDE

[#5]

Thank you. You have been very helpful.