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

[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.

 

[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?

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 Yin]

Hello Jan,

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

M

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?

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

 

[Jan Karel Pieterse]

Hi M,

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

Thanks for letting us know, much appreciated!

Regards,

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