Searchable drop down list as seen on google sheets (Data Validations)

[Jithe]

Hi Guys,

How do you create searchable drop down list as seen on google sheets? I have excel 2016. I want to use the drop down to complete a column in a table.

I know I have to use data validation.

Thank you.

 

[shg]

See https://www.contextures.com/xlDataVal01.html

 

[Jaafar Tribak]

You may also be intersested in this

Here is a fresh workbook example.