Siddharth Agarwal
New Member
Please let me know why is the below array formula not working:
{=SUM(IF(Timeline_1<0,Timeline_1,IF(F24<=VLOOKUP(Scenario_Description,$E$3:$G$12,3,FALSE),-$F$24*$C$3,0))*Likelihood)}
Timeline_1, Scenario_Description, Liklihood are all arrays
{=SUM(IF(Timeline_1<0,Timeline_1,IF(F24<=VLOOKUP(Scenario_Description,$E$3:$G$12,3,FALSE),-$F$24*$C$3,0))*Likelihood)}
Timeline_1, Scenario_Description, Liklihood are all arrays