Forum Discussion

Conor_Mck's avatar
Conor_Mck
Copper Contributor
Apr 20, 2023

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

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' 

   

 

 

admin
Excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Apr 20, 2023

    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.

Resources