How to have comboboxes in this situation?

Hi folks,

I've got this table structure:

[Attached image]

I'd like to have two different comboboxes with the information of both columns filtered. For example, if I select "Cars" in the first combobox, I should only see "Audi", "BMW" and "Mercedez-Benz" in the other Combobox.

I'm new to the Forum so please let me know if there's something wrong with my question.

Trying to find a solution here but so far no idea!

Thanks in advance!

Welcome to the Forum!

Don't attach a screenshot of your Excel file--just attach the file. It's easier than taking a screenshot first and then attaching that. And once we understand the problem, having your file will let us experiment with your data, formulas, and code, and possibly attach a file with a completed solution.

I have attached an example of one way to do this that required a slight change in how your data is organized. It also involves a couple of named ranges and named formulas. Let me know if you need a detailed explanation.