[Technic] Excel help

[Lori Kempker]

 Any Excel guru's out there that might be able to help with a Lookup 
function?  I have a list of student names and the student number on one 
spreadsheet.  I will have many spreadsheets with just student names on them 
and I would like to insert a formula to look up the student number and 
insert it in the second spreadsheet.  I am having to do this in our 
conversion from Lemco to PowerSchool.  We did not have a local student 
number in Lemco, only a social and MOSIS.  We created a Spreadsheet with all 
the student names and a 4 digit number.  As I print class rosters to file, I 
need to get the student number on the class roster spreadsheet in order to 
put it into PS.  Is this possible using a lookup function?

Thanks for any help.  I won't be able to try this until Thursday so if you 
can't reply until then, I'll still take all the help I can get.
TIA,
Lori Kempker
Technology Coordinator
Blair Oaks R-2 School District
6124 Falcon Lane
Jefferson City, MO  65101
(573)635-8514
lkempker at blairoaks.k12.mo.us