Conditional Copy of cells from one sheet/workbook to another

[xyzoblivion]

Hello friends i am new to excel and vba and i don't use it often.

I am stuck in a problem i don't know where to find it, google returns results but it is beyond my understanding.

my workbook has 2 sheets and i want to create a summary of it
Sheet 1 has a student list which contain 2 fields.
RollNumber and Name. It is populated with the full list of students eg. 100 students. "Sheet 2" has RollNumber, Name, Grade, GPA fields but with different arrangement and less number of students as they are removed because they are either Grade "F" or in attendance shortage.

Now i want all the student's Marks, Grade and GPA from "Sheet 2" to be pasted on sheet 1 so that grades are pasted in front of the correct students.

I think its a little too high for my level. Please help

Regards, and thank you in advance.

 

[Special-K99]

Use VLOOKUP

If you can provide an example sheet we can probably clarify this properly as we dont know what vlaues are in what column

 

[xyzoblivion]

Link to excel sheet is this

https://docs.google.com/open?id=0Bwev-TIZ7K1WMGY3Njc0ODItNTY2Mi00YzYyLWE0YWMtNjY0ODViYWRlNjBl

i want the data from sheet 2 to be copied to sheet 1 in it's correct location.

 

[xyzoblivion]

anyone ?? please help