Excel genius required - equation that takes user inputs, and searches table for results

Help, please!

*Example Excel File attached*

Help - Excel Forum.xlsx

I need a function that takes inputted min/max parameters, searches through a table, and then displays results that meet parameter constraints.

Another way of explaining this:

There are five students in a class: Amy, Sally, Mike, Bob, and Peter.
They all take four courses: Science, Math, History, and Economics.

I want a function that lets me input search parameters such as: I want to know which student scored >80 in Science AND >70 in Math AND >90 in History AND <50 in Economics.

The function should search through a table of all their marks and display who fell in those parameters.

Thank you so much. Hope this question made sense.