Multiple IF conditions

Copper Contributor

I am trying to get multiple IF condition based on below matrix but unable to get through:




If for example cell B2 in excel has Stage as Revises, my requirement is for IF condition in cell C2 to return value 0.6; likewise if M1, BPA - the related values listed should reflect in C#. The values are static and thus can be defined in formula itself.

3 Replies


But if B2 contains M1, should C2 return 0.6 or 0.16?

@Hans Vogelaar  I realized after posting there was a duplicate entry. M1 value is 0.6. 


With a small lookup table:


The formula in C2 is =VLOOKUP(B2,$E$2:$F$4,2,FALSE)

This can be filled down.


Without a lookup table: