Sorry - no idea how to explain this, let alone do it! Think it's an index/match combo but just can't get it to work...
Anyway what I'm trying to do:
On sheet 1 we enter all of the entrants names and some other details in A-D, then in cells E-Z you can type in what classes they're entering...