I don't know if anyone noticed but that INDEX function:

=INDEX(Sheet1!C1:C10,MATCH(A1&B1,Sheet1!A1:A10&She et1!B1:B10,0))
Entered with Ctrl+Shift+Enter

Actually gives you the student number AFTER the one you want (at least
that's what's happening to me).

It could be corrected by:

=INDEX(Sheet1!C1:C10,MATCH(A1&B1,Sheet1!A1:A10&She et1!B1:B10,0)-1)
Entered with Ctrl+Shift+Enter


--
malik641


------------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190
View this thread: http://www.excelforum.com/showthread...hreadid=468318