Lookup of two cells to find a third value from a table

[broncos347]

I have a risk register where I have a probability column (column K) and a likelihood column (column L), I can input a number between 1 and 5 in either of these columns.

I would then like to be able to lookup the values in these two columns on the table shown below so that I get the risk score shown in cells D3:H7. is anyone able to help?

Book1
	A	B	C	D	E	F	G	H
1	LIKELIHOOD			Very Low	Low	Medium	High	Very High
2				1	2	3	4	5
3	PROBABILITY	Very High	5	5	10	20	40	80
4		High	4	4	8	16	32	64
5		Medium	3	3	6	12	24	48
6		Low	2	2	4	8	16	32
7		Very Low	1	1	2	4	8	16
Risk Weightings

 

[Tim_Excel_]

I assume there is some kind of mathematical logic to the table shown in your post. Are you unable to use this formula to calculate the results, opposed to having to look up values in said table?

 

[Aladin Akyurek]

=INDEX($D$3:$H$7,MATCH(J2,$C$3:$C$7,0),MATCH(K2,$D$2:$H$2,0))

where J2 is a prob value and K2 a likelihood value.

 

[broncos347]

Aladin, works perfectly many thanks.

 

[Aladin Akyurek]

Aladin, works perfectly many thanks.

You are welcome.