Please can someone help with my dilemma:
I need to notify line managers which of their team are out of date with training requirements
Colum A is Line Manager
Column B is staff member
Columns C-E are for training results, Capacity,Fire and Equality. The only entry in these columns would be "non compliant", although some cells may be blank.
I'd like a formula to look up a specific line manager in column A, e.g: Mandy Jones, then look up "non compliant" in column C for example and then show the result as the corresponding staff member.
Is any one able to help with this?
I need to notify line managers which of their team are out of date with training requirements
Colum A is Line Manager
Column B is staff member
Columns C-E are for training results, Capacity,Fire and Equality. The only entry in these columns would be "non compliant", although some cells may be blank.
I'd like a formula to look up a specific line manager in column A, e.g: Mandy Jones, then look up "non compliant" in column C for example and then show the result as the corresponding staff member.
Is any one able to help with this?