Searchable Drop down and type selections

[TessaJ]

Hi all!

Is it possible to have a searchable drop down list in a row with certain selections of customer names and still be able to type in the row if the customer name is not in the drop down? If so what is the best way to go about this?

 

[Joe4]

I don't know if that is possible.

I assume that this drop-down list is Data Validation that is being populated from a data list somewhere.
Where is this drop-down list being populated from?
I would be more apt to have them add the new contact to the place that holds the values being used in the drop-down list, so it can be selected.
You can either include a bunch of blank rows at the bottom of the list, so when new values are added, they automatically show up in the drop-down list, or you could use VBA to to adjust the range used.

 

[Kunal Ravi]

Hi all!

Is it possible to have a searchable drop down list in a row with certain selections of customer names and still be able to type in the row if the customer name is not in the drop down? If so what is the best way to go about this?

Thank you so much for posting this question
I would appreciate if fix this que with VBA along with using a cell

 

[Joe4]

Thank you so much for posting this question
I would appreciate if fix this que with VBA along with using a cell

Please continue on in your original question here: Searchable Drop down list using a cell

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.