Hi All,

i would like to see if anyone can help with the following:

Based on ITIL, I would like to create 2 dropdowns (one based on Impact, the other on Urgency) that are populated with the values 1-4. Based on selecting both Impact and Urgency, in a third cell the resultant Priority would be shown. The kicker is: if a "weight" can be attached to provide granularity to the Priority (ie. Impact =1, Urgency =1; Priority =1 with a weight of 29....Impact =2, Urgency =3; Priority =3 with a weight of 15 and so forth).

I attach a sheet showing the matrix and weights and look forward to one of you geniuses to have a crack at solving this.

I am by no means an Excel head....have tried many times to get my head around formulas just never got further than the basic ones

Cheers!

PriorityMatrix.xlsx