Combine to sets of data

I have two sets of data for students. One set contains all the students with certain test scores, taking up columns A to N. The other set contains about 80% of those same students with a different set of test scores. Students are sorted by ID numbers. How do I combine the second set into columns O to V so that student ID numbers match and it inputs the rest of the student data into the sheet.

I know there will be some blanks because not all students will be there but I need them to match up, even with the blanks. Any help would be great! Thanks.

Assuming the ID is in column A of both sets of data (assumed to be on different sheets), then you can use this in O2 of the first sheet:

=IFERROR(VLOOKUP($A2,Sheet2!$A:$N,COLUMNS($A:B),0),"")

Then copy across and down as required.

Hope this helps.

Pete

THANK YOU THANK YOU THANK YOU! I spent hours last week trying to figure that out. THANK YOU!!!