Search and Display

Really the easiest way to do that is just to apply filters to your original data: filtering at A2 and C2, to show Class one's 10 year olds... see sheet. I have hidden my results table so you are looking just at the effect of the combined filters

If you're wanting to do this on another sheet, it would be possible... just. So what exactly would you want to do. You would need to be 100% specific about your requirements AND you would need to include desired ALL searchable fields in your specification.

If you want to do multiple criteria searches (several criteria at once), you're probably better of just filtering the data....