Index match vs. If/countifs

[that_one_girl]

I have a need that I can’t seem to find a resolution to.
I need a formula that will

2. look in Training Records workbook, Column E for a name in the Staff List workbook, tab1 Column A.
3. If that name is in both locations, then search all records with that staff name in Training Records workbook, Column C, against the list of classes in Staff List workbook, tab2 Column A.
4. If it finds that employee in the Training Records workbook, with 2 or more of the classes listed in Staff List workbook tab2 Column A, then populate with “TRUE”, if not, leave blank.

SO:
Look in book 1, 5^th column – is employee frombook 2, pg. 1, 1^st column listed here? (YES)

Ok doesthat employee have 2 or more of the classes listed in book 2, pg. 2, firstcolumn listed next to their name in book 1, 3^rd column? (YES)
Ok – fill cell with “TRUE”
If not, leave blank.
L Anyone able to help? I’ve tried VLookup, butthe problem with that is that the employee name is to the right of the courselist in book 1. I don’t understand Index Match enough to create a formula. Ialso tried IF with AND but that didn’t work either.

 

[RasGhul]

Could you maybe post more data where you expect to see true values to see if my solution works?