From a table

[timspin]

HI all,

Weekly Report1.xls
	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
16
17
18
19												Table	Risks
20												IMPACT
21						I	P				Probability		Low	Med	High
22												Low	Low	Low	Medium
23												Med	Low	Medium	High
24												High	Medium	High	High
25
26
27
28
29
30
Front Sheet

id like for the cell o22 to o25 to populate depending on the cells M22:M25 and N22:25 - matching with the table to the right. You choose via data validation : list - either High - Med - Low for Impacts (I) and Probability(P).
Example : I is Med and P is High so therefore risk is High

Please help!
Cheers
Tim

 

[erik.van.geit]

Hi, timspin,
try this
=INDEX($T$22:$V$24,MATCH($M22,$T$21:$V$21,0),MATCH($N22,$S$22:$S$24,0))
kind regards,
Erik

 

[timspin]

Cheers Eric - thats the one!!