Calculating Values out of a matrix setup

i was wondering if anyone could help me with this?

I have an easy matrix setup where previously it asks for a stress level and fracture toughness. Each with a rating of 0,1 or 2. and my chart is setup like so...

0 1 2
0 0 1 1
1 1 1 2
2 1 2 2

So that the top and left hand side are the ratings and I want to use both values to come up with a final rating... So say if Stress level is 0 and Fracture toughness is 2 I get an overall rating of 1. Is there a command in excel where another cell will automatically solve for my final rating? An If statement does not seem to get me to where I want.. any help would be appreciated..

I have attached a sample of my chart. The first two peach areas are the selections you would make and I want to turqoise position to automatically select the correct rating from the chart.

Thanks.

The logic behind the chart is not mine. It was given to me. I know it really does not make sense to have a 2 and 0 and come up with an overall rating of 1, but thats how this process works. Im just trying to automate the process because I need to overall value to be outputted. I've tried using If then statements through VB but that doesn't quite work for me either, I don't want to have to setup a module or a button on the screen, I'd just like it to be automated

When Cell P8 has a 2 input and cell P13 has a 0, I want cell P20 to automatically determine 1.. Or if p8=1 and p13=2 then p20 automatically updates with a 2... so on and so forth...
Thanks for the help

Try this, I believe it should work for Excel 2003. Copy and paste the formula into your cell E17.

Please Login or Register  to view this content.

sorry i just uploaded a portion of my overall sheet.. just the section im dealing with... so you are right in ending at D17.. On my main worksheet im in the P column

thank you.. this little formula worked just like i need it to...