Ways to filter automatically

[HopefulSal]

Hello There,

I currently have a spreadsheet tab with a search function which pulls data from another sheet within the doc. The search function has one primary search option and then a secondary. I need to be able to filter the secondary column to ensure there is no data shown which is inapplicable to the search option.

Is anyone able to help please, I've been stuck for 3 days and am very confused?