Excel 2007 : How to filter a range of values?

I have 2 excel files with the content as follows:
file1.xlsx

http://nl7.upanh.com/b2.s26.d1/0673b...43770247.a.png


in file2.xlsx contains some values match in the Student ID column of file1.xlsx. Now I want to filter marks of all students who have the student ID in file2.xlsx match with the ones in file1.xlsx. How can I do that? I have read the lookup function but this function can only look up one value at a time.

file2.xlsx

http://nl9.upanh.com/b2.s27.d2/baff9...43770249.b.png

It sounds like you should be able to use a lookup function; perhaps you could upload a (one) sample workbook with file1 in one sheet and file2 in another?

Try this in C4 of file1:

=IFERROR(IF(MATCH(A4,"reference to A4:A9 in file2",0)>0"MATCH"),"No Match") and copy down.

Then use filter on the table.

Is it something like that you need?