Hello,

I was wondering if someone could help me with the following.

I have 2 spreadsheets in a workbook. From the table in sheet1, I would like to lookup everyone that's enrolled in the workshop "7 Habits S1" and have their Last name, First name and Office enter in sheet2.

Thank you.

Attached Files

Test.xlsx (10.5 KB, 9 views)