Making Data Validation List Easier

Hi! I need some help making a data validation list easier to search/use. I have about 600 supplier names in my data validation list and it makes it really tedious to have to scroll down to find the right one in alphabetical order. Is there any way to make the list searchable? Also, if possible to make searchable it needs to be searchable in each individual cell as a new record is added almost every day with the supplier name (selected from the drop down list) and some other information. I have tried a combo box but it doesn't seem to work or I'm not doing it right. Any suggestions would be much appreciated. Thank you!

See the attached as an example of searchable drop down.

There are YouTube videos on this subject.

Thank you so much but unfortunately that is what I am trying to avoid. I can't have one search box the search box needs to be in each cell. I have attached a snapshot of what I mean. They choose from this drop down list every new entry. I need the drop down to autopopulate or search I'm not sure the proper term so that if they start typing abc in ONLY that cell all suppliers containing the letters ABC appear in the drop down list.
Capture.PNG

See

https://www.youtube.com/watch?v=0QrQT9D25Xk

This is what you require.

Thank you! This does seem to be what I require however when I tried it I had no luck. The formula =cell("contents") wouldnt recognize as a formula.

Attached is sample of multi-drop down

C2 = Cell("Contents")

Yellow cells are the drop downs