Hi all, and Happy Friday!!!!

Okay I am writing a formula on the sheet named PA - CAPA on the attached workbook.  The formula will look at data on the Training Report sheet and needs to be based on an IF/AND condition. 

For example the first formula will be in cell C2, and all formulas in the table, I anticipate will have basically the same formula.  IF (Training Report[User Full Name] = 

I came up with this, but it is not right.  One of the issues is that the Training Report contains the names for each training a person has done, and of course the Training titles are also listed multiple times.  Is there a way to get a T/F based on Columns A/I as my data?

=AND(IF(Table1[User Full Name]=@[Primary Approver)*(Table1[Curriculum Title]=Table2[[#Headers],[Training - ABC]],"TRUE","FALSE")

UPDATE:  I finally figured it out!!!  If anyone has a similar issue, my solution was:

=IF(COUNTIFS(Training_Report[User Full Name], [@[Primary Approver]], Training_Report[Curriculum Title], "AMER - LATAM - SSC - CAPA Specialist") > 0, "Yes", "No")