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

Try...

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

Hope this helps!

In article ,
"Luc" wrote:

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

Thanxx, it did the job !!



"Domenic" wrote in message
...
Try...

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

Hope this helps!

In article ,
"Luc" wrote:

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