If Function isn't working properly

If Function isn't working properly

I'm trying to pull out only Salary Earnings from a Payroll tab to "Salary
Earnings" column on Unique payroll tab using this "IF" function:
=IF(Payroll!F2="Salary", Payroll!G2, " ") but in some reason it's skipping
the salary on the same date as bonus.

I even tried the below one, and it's leaving D5, D6, and D7 empty.
=IF(AND(Payroll!F2="Salary", Payroll!C2=UniquePayPeriod!C2), Payroll!G2, " ")
Can anyone help please? Thanks!