Create a seating chart

Sorry to take so long to get back to you.

I've updated your sheet a bit - I've added 3 'helper' columns to the students sheet. These allow for duplicate names without the formula getting stupidly large. These columns can be hidden, or moved to elsewhere on the same sheet, if you prefer.

As for B185 - that had me stumped for ages. The issue is that there's only one student called Haas, but he appears twice on the seating chart (A-R10 and H-L6) and this is what's confusing the formula.

The Haas in A-R10 has been written into the cell, rather than populated by a formula, so I assume that's the 'wrong' answer, but I'm not sure.

Anyway, updated version of your sheet is attached.