I am sorry for the delayed response, please check this formula - it should work:
Formula for Secretary Column: =IF(COUNTIFS([Book1]Sheet1!$B:$B,$B$1,[Book1]Sheet1!$A:$A,A2),"Yes","No") Formula for Admin Column: =IF(COUNTIFS([Book1]Sheet1!$B:$B,$C$1,[Book1]Sheet1!$A:$A,A2),"Yes","No")
Please do write back to me, if you need any further clarification about these formulas.