How do I pull a particular set of records from a larger file?

M

M Yin

About 2000 students took Test A, and I have their scores and student numbers
in an Excel file. About 500 of those 2000 students also took Test B, and I
have their scores and student numbers in another Excel file.

I would like to copy the Test A scores of those 500 students into the same
file as the Test B scores so I can then compare them. Is there a way for me
to do this without having to go through the Test A file student by student,
manually finding and copying the scores of those 500 students?

Thanks for any help.
 
J

Jan Karel Pieterse

Hi M,
I would like to copy the Test A scores of those 500 students into the same
file as the Test B scores so I can then compare them. Is there a way for me
to do this without having to go through the Test A file student by student,
manually finding and copying the scores of those 500 students?
Click to expand...

This calls for the VLOOKUP worksheet function.

Say your student names are in column A, starting from row 2 in both files.
Say Grade set A is in FileA.xls (Sheet1).
Say the grades are in column D:

Open both files.

type this formula in fileB:

=VLOOKUP(A2,'[FileA.xls]Sheet1'!$A$2:$D$2002,4,False)

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
 
M

M Yin

Hello Jan,

That did the trick. Thank you very much for that; it saved us a LOT of time!

M

Jan Karel Pieterse said:
Hi M,
I would like to copy the Test A scores of those 500 students into the same
file as the Test B scores so I can then compare them. Is there a way for me
to do this without having to go through the Test A file student by student,
manually finding and copying the scores of those 500 students?
Click to expand...

This calls for the VLOOKUP worksheet function.

Say your student names are in column A, starting from row 2 in both files.
Say Grade set A is in FileA.xls (Sheet1).
Say the grades are in column D:

Open both files.

type this formula in fileB:

=VLOOKUP(A2,'[FileA.xls]Sheet1'!$A$2:$D$2002,4,False)

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Click to expand...
 
Top