Forum Discussion
Tracey_Cregeen
Jul 26, 2023Copper Contributor
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...
OliverScheurich
Jul 26, 2023Gold Contributor
=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?