Forum Discussion
lookup with multiple conditions and date range
Hi Team, please help me to get the data based on below requirement. Please help to me with relevant formula/looks. Discount% required in the Product Purchase Table 1 where Purchase date in tab...
=IFERROR(INDEX($D$12:$D$15,MATCH(1,(A3=$A$12:$A$15)*(B3>=$B$12:$B$15)*(B3<=$C$12:$C$15),0)),"")If you don't have access to the FILTER function you can try INDEX and MATCH. Enter this formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.