l am looking for an anwer how to enter a student's id number and do a vlookup that would populate a spreadsheet his name, grade, and time stamp. This will be done with a scanner in the library as multiple students come to the library. the attendant will scan the id and the formula will populate a ss with their names and time of entry.
We will have 1700 students in a ss and scan one student at a time as they enter the library. We will scan their id card and need the student name, grade and time stamp populated.
did you get my reply
Can you be a little more specific.
Here is what I need:
Sheet one: (a) ID, (b) Name, (c)Grade,(d) Time in
Sheet two: (a) ID, (b) Name, (c) Grade
Clerk will enter id in sheet one column a and when she does column b and c will be populated by sheet two info.
My school district has wikisend.com blocked any other address to send to