I work in an Financial Aid Office and need to know if students have attended spe

Question

I work in an Financial Aid Office and need to know if students have attended specific courses. Currently I am looking these up one by one for hundreds of students which literally takes hours. I'd like to know how to do a VLOOKUP or something similar to get what I need. The ID# and the CRN# need to match before returning the value of attendance as most students have more than one course that they are enrolled in and I need to know attendance for each course. I know how to do a general VLOOKUP to match one column (like the ID#) but I'm not sure how to add in the second column that has to match as well.

Here is a generic example of what I need. This information is on two separate worksheets (two completely different files).

Thank you in advance!!!

Sheet One Sheet Two ID# Name CRN Attnd ID# Name CRN Attnd 44252322 Jones, Bob 321420 44252322 Jones, Bob 321420 44252322 Jones, Bob 210145 44252322 Jones, Bob 210145 yes 44252322 Jones, Bob 100253 44252322 Jones, Bob 100253 yes 55578652 Smith, Sally 205542 55578652 Smith, Sally 205542 yes 55578652 Smith, Sally 245623 55578652 Smith, Sally 245623 no

Explanation / Answer

In cell D2 of Book1, enter this formula and copy down

=INDEX([Book2]Sheet1!$D$2:$D$6,MATCH(1,INDEX(([Book2]Sheet1!$A$2:$A$6=A2)*([Book2]Sheet1!$C$2:$C$6=C2),,),0),1)

Hope this helps.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---