Help: Dependent & Searchable Drop Down Lists

[rxk]

Hi,

I need help to make the Dependent Dropdown (Data validation on column G) searchable. I only using only Excel 2019 version.

See attached sample file.

[AliGW]

Please update your forum profile to your current version of Excel.

[AliGW]

Explain exactly what you mean by 'searchable' - do you mean that the list will home in on an entry as you start to type?

[rxk]

Profile updated Excel version 2019.

What I meant for searchable is that, in the cell with Data Validation, you can key in some key words and the drop down list will be narrow down the list depending on the entered key word.

[AliGW]

OK - so as you have 2019, this is still relevant to you: https://www.excelforum.com/excel-gen...-you-type.html

Let me know if you'd like this moving to the VBA section.

[rxk]

Thank you. Yes it is relevant.

I am looking on other option using formulas.

[AliGW]

You can't narrow down a DV list in that way using formulae.