Hi everyone,

I have a database with student grades and test scores that I'm trying to clean up. I have a list of about 2000 student ID #s in Column A. I then have a list of about 17000 student ID's in Column D with grades in each course the student took. Last, I have a list in Column H of about 25000 student ID's with test scores on each exam. Basically the list of 2000 student ID's are the only data I want. Is there any way to fish out those 2000 student's grade and test scores out of the other lists without going one by one? Any help would be greatly appreciated and save me probably 10 hours of work here. Thanks!!!