Forum Discussion
Multiple Lookup
I want to do a look up that will return the value in the table so if the work required affects Operation/service interruption Moderately but the probability of failure is unlikely that the cell for the look up returns the value 3.
Can anyone help?
@
2 Replies
Select the cells that describe the severity (Insignificant, Minor, etc.).
Name this range Severity.
Select the cells that describe the probability(Unlikely, Possible, etc.).
Name this range Probability.
Select the range with the outcomes (the colored cells).
Name this range Outcome
=INDEX(Outcome, MATCH("Moderate", Severity, 0), MATCH("Unlikely", Probability, 0))
Of course, you can use cell references instead of "Moderate" and "Unlikely".
=INDEX($E$10:$H$14,MATCH(A2,$C$10:$C$14,0),MATCH(D2,$E$9:$H$9,0))Does this formula return the intended result?
