Excel Wont "FULLY" Filter a column which contains drop down lists! Help Please

So, I'm writing a spread sheet that will help me look up part numbers for coaxial cable connectors. I want to open the spreadsheet, filter by the Cable type that the connector is manufactured for, then filter impedance, ***, connector type, etc... The problem arises because most connectors can be used on MULTIPLE coaxial cable types. So I've created a drop down list for the example connector @ cell B5. When I try to filter column 'B' with the filter widget @ B4 It doesn't list the other coaxial types contained in the dropdown list in cell B5 . Is there any way to get excel to do this?

I'm using excel 2010, and here is the spreadsheet as an example.. Coaxial Connectors.xlsx

Thank you all for your help!

Caleb

It does exist.....kinda.
Any way I might achieve this functionality?

Would a vlookup or hlookup do the trick?

Thank you for your input, evidently I have a fundamental misunderstanding of what exactly a drop down list is. If you have any methods for me to do this correctly, I'd certainly love to hear it.