IF Function Formula Help

[VEROSSA_X]

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.

 

[jasonb75]

Try

=IF(COUNTIFS(A:A,"Doe, John",B:B,"024.001.006",C:C,"<>"),"yes","no")

 

[njimack]

=IF(SUMPRODUCT(--(A1:A17000="Doe, John"),--(B1:B17000="024.001.006"),--(C1:C17000>1)),1,0)

 

[VEROSSA_X]

Amazing. I love smart people. Thanks for your help and the quick reply.