Hello,
I need some help writing a formula the will help me determine if an employee is qualified on a given task.
Basically, search employee names in A:A, look for the corresponding task number in B:B, and C:C contains a completion date.
I've been combining the IF and AND functions with some results, but it will not seem to find the task number in B:B.
Currently using (=IF(AND(A:A="Doe, John",B:B="024.001.006",C:C>1),"yes","no")
Also, not sure if it matters, it's searching through 17K rows of data.
Thank you for your help.
I need some help writing a formula the will help me determine if an employee is qualified on a given task.
Basically, search employee names in A:A, look for the corresponding task number in B:B, and C:C contains a completion date.
I've been combining the IF and AND functions with some results, but it will not seem to find the task number in B:B.
Currently using (=IF(AND(A:A="Doe, John",B:B="024.001.006",C:C>1),"yes","no")
Also, not sure if it matters, it's searching through 17K rows of data.
Thank you for your help.