I need help to do a vlookup with if statement together
Sheet 1 - Column A: Dates, Column B: Names:, Column C: Control Numbers,
Sheet 2 - Column A: Dates, Column B: Names, Column C: Code Numbers,
In Column D on sheet 2, I want to see the Control Number for the specific
Name and specific Date.

This is what I have in D1 =IF(A1=Sheet1!A:A,VLOOKUP(B1,Sheet1!$A$1:$C$100,3) )
Instead of getting the Control Number I get FALSE
What am I doing wrong? Can you please help?