How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Richard Your Own Question
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 37561
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

vlookup for attendance

This answer was rated:

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.

Thank you for your question, my name is Richard.

the basis of the Vlookup is as such.

you put the formula in the Cell you want to display one of the results, in my example the Name.

The format of the vLookup is as follows

=vlookup(lookup value, table where values reside, column # XXXXX values are located, false)

So in out example, the lookup Table is the actual value we are looking up, in your case it is the Student ID, so lets say that is in Cell A1

Then the Table where the Values reside, is where the Student ID and Name are stored. This will be large I assume and in our example, we use rows A & B (so B being the ID's and C being the Name's)

The last is the Colume number, so which columne value we want to return. So in this example, as Name is XXXXX XXXXX we specify 2.

and thats it. The formula will look at the ID in A1, search through the lists of ID's and Names in columns B & C and return the name from C

I also have a tutorial on how this works which you can view here.

Let me know how you go, and if you have any difficulties, please do not hesitate to let me know.

Thank you

Customer: replied 3 years ago.

did you get my reply

No sorry, just this reply.

Customer: replied 3 years ago.

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.

Can you supply me the sheet?

then I can do it directly on this

- Click the following link:
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"

Thank you
Customer: replied 3 years ago.

My school district has blocked any other address to send to


Customer: replied 3 years ago.

strange, but it does not want to download

Can you upload again and give me the new link please?
Customer: replied 3 years ago.

Sorry, I bet the school is stopping the upload.

I did an example though for you here

You will see that it works as you required in your example.

Let me know how you go when reviewing it please.

Richard and other Microsoft Office Specialists are ready to help you