SUMPRODUCT Help

[HopDevvil814]

I want to look at the schedule(sheet 2) and compare to see if a person shows up on sheet 1. I want to compare emp ID, date, shift.

It should look at F2 on sheet 2 and look for that data in column A on sheet 1, then look at B2 on sheet 2 and look for that data in column D on sheet 1. The third part should check column 3 on sheet 2 to see if the value = "shift"

The code currently in AA is not working properly, I have also tried these:

=IF(SUMPRODUCT(--(Sheet1!$A$2:$A$50=INT(Sheet2!F2)),--(Sheet1!$D$2:$D$50=Sheet2!B2),--(Sheet2!$C$2:$C$50="Shift"))>0,TRUE,FALSE)

=IF(SUMPRODUCT((Sheet1!$A$2:$A$50=INT(Sheet2!F2))*(Sheet1!$D$2:$D$50=Sheet2!B2)*(Sheet2!$C$2:$C$50="Shift"))>0,"Shift","No Shift")

I guess I am not understanding why I cant switch the values around in the SUMPRODUCT. I even tried to simplify it and still didn't have any luck.

[Kaper]

Why do you think it is wrong.

In F2 all conditions are met in rows 12, 13, 14, so the result is true
in F3 - no TAB0100420 in column B so rows where all 3 conditions are met.
F4 - again OK, as in rows 30,31 and 32 all conditions are met
F5 - no TAB0100965 data for 05.11.2020

[HopDevvil814]

It should work, but it doesn't reflect that in AA. Not sure what I am doing wrong.