MATRIX help

[bigbill]

Hi I want to select 2 inputs from 2 drop down lists (done) on a risk matrix ie "possbility" against "severity" and have another cell automaticaly input the HIGH MEDIUM or LOW from my existing excel 4 x 5 matrix in the same colours.

Column4 Column5 Column6
Very Serious Rare


Rare Unlikely Possible Likely Almost Certain
Major MEDIUM MEDIUM HIGH HIGH HIGH
Very Serious LOW MEDIUM HIGH HIGH HIGH
Serious LOW MEDIUM HIGH HIGH HIGH
Significant LOW LOW MEDIUM MEDIUM MEDIUM
Slight LOW LOW LOW LOW MEDIUM
No Impact LOW LOW LOW LOW LOW




Appreciate any help for a novice user

Best regards

[zbor]

something like this?

Book1.xls

[shg]

Please post an example (workbook) of how you would like the risk register to appear.

[bigbill]

Thanks for taking the time to answer me. I have attached an example.

With regards
Bill

[zbor]

as I write you in example.. Just adjust formula to your cells:

=INDEX(MATRIX!$I$6:$M$11;MATCH(E4;MATRIX!$H$6:$H$11;0);MATCH(F4;MATRIX!$I$5:$M$5;0))

(and with conditional formating you can make different colors for low, media and high..

[bigbill]

Thanks Zbor,

Error indicated in the $M$11 in the formula

I will read through help and try to sort out. I thank you for your kind assistance
Bill

[shg]

Try changing the semicolons to commas; it's an Excel regional thing.

I still don't see what you want to do; there's no example output for your example input.

[bigbill]

Example input and output attached. I want to be able to select the severity and likelyhood and have the "Risk" cell populate atomticaly based on the MATRIX on the MATRIX worksheet.

Kind regards

[bigbill]

shg and zbor THANK YOU very much, I changed the semicolons to comas and formula worked - Fantastic

How do I show this thread as closed?

regards
Bill from Australia

[shg]

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes

[Alag8ter]

Hi Bill,

I have been trying to do the same thing. Any chance of getting a copy of the final excel spreadsheet?

Regards.

[zbor]

Sometimes even small changes i your data can result with totally different approach.
So you should better open new thread and explain your problem.
Post a sample workbook. That will give you result much faster.

Also, it's against the rule numer 2: Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.