Hi All

I'm trying to produce a list of students that meet three criteria i.e. target grade, actual grade and class.

The specific grades come from a count and refer to the active cell.

For example; if I click on G16 and refresh
L2 displays B
L3 displays B
L4 displays 10wx/Sc2
L5 displays 2 as there are two students who fit the above criteria.
Below that should be their names "dfag" and "dfg".

I found those two names by filtering, which is pretty much what a pivot table would do. However, I would like it so I could click and refresh. This will save a lot of time in the future when I have to look up lots of results for reports.

I used this video (Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula - YouTube) to build the formula in L6> but it just returns #N/A. I can't find what is wrong with it!

I've uploaded my sheet to here (https://app.box.com/s/5u1stkmhuaegzy1zmv1r) and would really appreciate if anyone, could help.

Thanks