Worksheet VLookup Newbie Help

I have a problem. I have two worksheets one with classes and one with student info and I wanted to pull certain info from one worksheet to the other
for example
Student 1 appears 3 times under three different classes…That student has three fields of info on the other worksheet written 1 time. It needs to automatically pull the info from the 2nd worksheet list below based on ID number and fill it in to all the occurences of that student...I am using a Vlookup function but it is not working properly

If you can help I have a sample excel file I can send....xls is an invalid file extension here

any help would be appreciated
-M

you can zip your xls and post it here. It would be easier to see the worksheet. How do you know on worksheet 2, that there are 3 occurrences of the student on worksheet 1?

Thanks for the zip tip

I need the last few columns of first worksheet to reflect the info in the second...based on each student...
I am getting "0" and NA messages..

You have actually done it correctly - well done The issues you are having are three fold.

Firstly the student list on sheet 2 needs to be sorted in student number order. This is because Vlookup starts at the top of the list and then works down until it finds the number. If it overshoots based on alpha, it assumes the number is not there. Just select column C and click A to Z sort from the tool bar, and it will start working as you expect.

Secondly, the zeros that are returned are just a formula representation of the blanks in your table. You can either switch of zeros on your destination sheet by selection Tools\Options and deselecting View Zeros, or you can filter them out by putting an if statement around your vlookup

ie =if(result from vlookup=0,"",result from vlookup)

Thirdly, Vlookup has a 4th option argument. You should put comma 0 at the end of your lookups. ie

=VLOOKUP(C3,Modifications,2) should be =VLOOKUP(C3,Modifications,2,0)

The default use of vlookup is to find the closest match. If you don't put ,0 at the end, the vlookup will return a different student's details if the number can't be found.

Matt

Thank you so much for the help...worked great...This is a great forum!