Compare 2 Sheet and by 2 column and compare date get the value on sheet 1

[parscon]

Hello To All ,
I need a VBA That can compare Column B and C and F (Date) on Sheet 1 with the same range on sheet 2 and find the same value and the date that to be same or before the date on Sheet 1 . (Only one and if cannot find the date put error Error)
if you see the below image you can see it .

Result.jpg