Hi!

I got a dependent drop-down list on my excel, is it somehow possible to make it searchable?

Currently it is like this:

Cell B8: select product group (Drop down)

Cell B9-B179 Select product status (Dependet on B8 drop down)

I want to be able to search the product status in cells B9-B179
(we got over 55 different statuses all starting with a number code, its a bit of a hazzle)