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

Copper Contributor

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' 





1 Reply


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.