# IF Function Formula Help

#### VEROSSA_X

##### New Member
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.

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
Try

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

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

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

Replies
16
Views
960
Replies
1
Views
605
Replies
3
Views
332
Replies
3
Views
1K
Replies
4
Views
1K

1,196,369
Messages
6,014,885
Members
441,854
Latest member
Amstaff

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back