Help - What's the best forumla for a lookup between 2 dates based on a product code?

[Conor_Mck]

I was wondering if someone could help - need help with a forumla 

I need to return a price for the product code in colmn E below (possibly with a lookup), 

from the sheet  'PricefileLookup' below based on the below despatch  date in column A (pic 1) falling betwwen that date in colmn A and B in 'PricefileLookup' based on it matching the prodcut code column E in 'PricefileLookup' 

   

[#2]

@Conor_Mck 

In R2:

=IFERROR(INDEX(PriceFileLookup!$D$2:$D$10000, MATCH(A2, IF(PriceFileLookup!$C$2:C$10000=E2,PriceFileLookup!$A$2:$A$10000))),"")

If you do not have Microsoft 365 or Office 2021, confirm by pressing Ctrl+Shift+Enter.

Fill down.