I have a master attendance worksheet with instructor names and their students. I would to separate/create worksheets for each instructor with their student attendances. In addition, I would like to student attendance of each instructor to show up in the master attendance worksheet. So far, I have used the following formula:
=IF(ISNA(VLOOKUP($A$1,MASTERLIST!$A$3:$C$11,2,FALSE)),FALSE,VLOOKUP($A$1,MASTERLIST!$A$3:$C$11,2,FALSE))
All I get is the first matching student for the instructor but not the rest of them. Any help will be mightily appreciated.