Returns a single result based on multiple criteria

See the attached:

I used a series of Lookup tables to determine a unique (I hope) combination for each prize.

The base formula is a simple match

=MATCH(A2,F$2:F$6,1)

I produced a table for all 38 combinations and using the same MATCH technique determined the combination "code" for the sample. I then used a VLOOKUP to get the Prize text.

See tab "Criteria (2)"


Further check on ensuring combinations are unique highlighted that Prizes 14 and 22 have same criteria.