Formula to show each days value

Hi

Please can someone help me with an advanced formula, I attached my sample file.

I need a formula in B43 to display the value E2, but it needs to find the corresponding date in colomn A as per the date in row 42 and find the Area as per A42 and then display in B43 "1819"
the same must happened is B44 to show the value from F2

I want to be able to copy the formula accross to the right for each date

Thank you in advance

Hi Fred

Thank you, it works, however, it need to check the Area also. I added below the relevant info, see orange and green

Will really appreciate it

Thank you Fred