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' 

Conor_Mck_0-1681997745896.png   

Conor_Mck_1-1681997957073.png

 

 

1 Reply

@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.