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 th...
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".