Can this be done? I have a worksheet that I use to track scores on
the Army physical fitness test. I use the sheet for unit level events
so there are soldiers from 5 different platoons. I would like to pull
the data from this input sheet into a seperate sheet for each platoon
that lists scores by name. The problem is there are multiple
instances of the lookup values(platoon) on the input sheet and I also
need the lookup to return the name which is in column A. I don't
think I can use individual names as lookup values because soldiers
come and go? Is there a way to use the name if it also meets another
condition? Please see example below.

NAME PLT SCORE GO/NO-GO
Johnson 1 300 GO
Smith 2 179 NO-GO
Thomas 3 245 GO
Allen OPS 220 GO
Roberts HQ 250 NO-GO
Myers 1 249 GO