Hey - I have spreadsheet with a list of student names and the subjects they have chosen for the year. I'd like to be able to create a search cell where I could type in the subject and the name and surname of all the students that have chosen that subject appear. I can't upload the actual sheet so I've made a much smaller version so you can hopefully see what I'm asking.