• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Formulation : Vlookup inside Array formula

S

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
 
You must log in or register to reply here.
Back
Top