Re: Help with creating an exam book..

Sarrah,

the information you have provided is still very sketchy, but perhaps
the following might help you. You ask how you can get student
information from student list by typing student number, so this implies
that you have student data along the lines of:

A B C D
Number Surname Forename D.O.B. etc
0001 Smith Jane
0003 Jones David
etc

You will probably have lots more information in this table, but you
want to type student number on one *** and have some of the
information from the student list to appear. Assume that the table
above occupies cells A1 through to D500 in the *** called "Students".
Assume further that you want to type a student number into cell A2 on
another *** for results - the following formulae can be entered:

B2: =VLOOKUP(A2,Students!$A$2:$D$500,2,0)
C2: =VLOOKUP(A2,Students!$A$2:$D$500,3,0)
D2: =VLOOKUP(A2,Students!$A$2:$D$500,4,0)

B2 would return the surname of the student whose number is typed into
cell A2, and the forename would appear in C2 along with the date of
birth in cell D2. You could copy these formulae down and then enter
other student numbers in cells A3, A4, A5 etc - these would not have to
be in the same order as in the main table.

Hopefully, these comments will help you progress a bit further.

Pete

.