I use a UDF called VLOOKUPS, a beefy version of VLOOKUP except it
returns a array of answers. It would pop out a list of all 9 classes for
any student you selected.

I've explained it more clearly he

'Excel Help Forum' (http://tinyurl.com/bahg77)

If you post a message to JBeaucaire on that forum, I can send you a
sample spreadsheet tailored to your data, it's pretty simple once you
see it in action.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58320