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...
gsabbella, Try using the following,
=IFERROR(FILTER(IF(C4=$C$14:$C$17,IF(D4>=$D$14:$D$17,IF(D4<$E$14:$E$17,$F$14:$F$17,""),""),""),IF(C4=$C$14:$C$17,IF(D4>=$D$14:$D$17,IF(D4<$E$14:$E$17,$F$14:$F$17,""),""),"")<>""),"")
Attached file for your reference. but you need to have the discount for the date in table 2, else you will get a blank cell.