Vlookup or what should i use ?

[Luc]

My problem :


I have 2 cells:
One cell is named "Severity" (allowed inputs are L, M, H)
The second cell is named "Probability" (allowed inputs are also L, M, H)

I want the third cell (named "Risk") to contain the result of "Severity" and
"Probability", which is retrieved from the 'Riskmatrix'




Example of the matrix (the name of this matrix is "Riskmatrix")

L M H (Row severity= first row)
H x y z
M x1 y1 z1
L x2 y2 z2

Column Probability (= first column)



Example :
Severity = M
Probability = L

=> Value of Risk cell should be y2

What formula should i put in the Risk cell?

Thanxxxxx,

Luc

 

[Domenic]

Try...

=INDEX(Riskmatrix,MATCH(Probability,INDEX(Riskmatrix,0,1),0),MATCH(Severi
ty,INDEX(Riskmatrix,1,0),0))

Hope this helps!

 

[Luc]

Thanxx, it did the job !!

Try...

=INDEX(Riskmatrix,MATCH(Probability,INDEX(Riskmatrix,0,1),0),MATCH(Severi
ty,INDEX(Riskmatrix,1,0),0))

Hope this helps!