greg_c
asked on
Formula for a Matrix
Hiya
I was wondering what formula would be useful for a matrix (please see attached). For example, if the likelyhood is rare, and the consequence is insignificant then the answer would be L (cell E42).
Would anyone have a suggestion of the best formula to use?
Thanks.
Greg
Test.xls
I was wondering what formula would be useful for a matrix (please see attached). For example, if the likelyhood is rare, and the consequence is insignificant then the answer would be L (cell E42).
Would anyone have a suggestion of the best formula to use?
Thanks.
Greg
Test.xls
=INDEX(D6:H10,MATCH("Rare" ,$C$6:$C$1 0,0),MATCH ("Insignif icant",$D$ 5:$H$5,0))
If A1 and A2 contain the words "Rare" and "Insignificant" then you can use
=INDEX(D6:H10,MATCH(A1,$C$ 6:$C$10,0) ,MATCH(A2, $D$5:$H$5, 0))
=INDEX(D6:H10,MATCH(A1,$C$
use of index and match like this example
http://skp.mvps.org/xl00002.htm
will provide you with a sample file with your data shortly
http://skp.mvps.org/xl00002.htm
will provide you with a sample file with your data shortly
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
your should "lock" the data range in the formula with absolute reference in order to be able to copy the formula properly.
ASKER
Thank you, and apologies for the delay in responding.