Vlookup or what should i use ?
 

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

Vlookup or what should i use ?
 

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

Vlookup or what should i use ?
 

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