matrix problem

Hi,

I am trying to compare two cells that have contents selected from drop-downs to be able to write a resultant word in a third cell which will be conditionally formatted as a result.risk matrix.xlsx

The resultant cell requirement is derived from a risk classification matrix. The matrix is included for ref.

I have been able to do a nested if,or,and to get extreme and/or high results but can't work out how to get medium or default of low.

e.g. the cells interact in the following manner:
if consequence selected as catastrophic and likelihood cell selected as almost certain then risk cell will have "extreme" entered automatically etc,etc as per the matrix.

I'm probably missing something straightforward but it's late and I'm running out of puff!!

cheers

Originally Posted by Ace_XL

In C2

=INDEX($C$9:$G$13,MATCH(B2,$B$9:$B$13,0),MATCH(A2,$C$8:$G$8,0))

Copy down

Hi, Only returning "N/A"...

cheers for the point tho.

RP

Originally Posted by Tony Valko

Try this...

=VLOOKUP(B2,$B$8:$G$13,MATCH(A2,$B$8:$G$8,0),0)

Note that some of your Consequences and all of the Likelihoods have leading space characters.

Hi,

Thanks for the replies. Noted the spaces just now(before I read yr reply) and retyped and viola! Again, many thanks in your assistance of a mere novice.

Cheers

Richie