Forum Discussion
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. Than...
I converted the lists into Excel tables.
=LOOKUP([@[Sales date]],Tabelle2[Sales date (Start)],Tabelle2[Payment date])