Accessing students' grades with their IDs

Hi guys,

I am a teacher and I need help on how I can create an excel file with my students' grades. I want them to access their grades by keying in their ID number. They can only see their grades for the various activities like exams or homeworks by inputting their ID numbers. I would really appreciate any help on this. Thanks a lot.

Name a cell ID
Name a range Data
Make sure that student IDs are the left most column of the Data range
Make sure that the grade is the 2 column of the Data range
use this formula:
=VLOOKUP(ID,DATA,2,FALSE)

Originally Posted by tlafferty

Name a cell ID
Name a range Data
Make sure that student IDs are the left most column of the Data range
Make sure that the grade is the 2 column of the Data range
use this formula:
=VLOOKUP(ID,DATA,2,FALSE)

Thanks. Sorry for not making myself clear. What I meant was is it possible for me to create a protected worksheet which the students can access only by inputting their ID to view their grades? They will not be able to see the grades of their classmates but only their grades.
Thanks a lot.