Forum Discussion

Kellychai's avatar
Kellychai
Copper Contributor
Jun 20, 2023

Lookup date range

Hello All,

I want to lookup one table within date range in another table. 

Could you share with me any formulas can use? Below is the sample, I need to fill up the payment date under column B. Thanks!

eg: sales date on 01 Jan, Payment date falls within the sales date range 26/12-01/01, payment date on 09 Jan

 

 

excel

1 Reply

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Jun 20, 2023

    Kellychai 

    I converted the lists into Excel tables.

    =LOOKUP([@[Sales date]],Tabelle2[Sales date (Start)],Tabelle2[Payment date])

     

Resources