I currently have a Matrix table below which contains the values I want
returned when the 2 columns - Impact Degree & % Customer Impacted are
populated.

% Customer Impact
Impact Degree <2% 2%-10% 10%
Nil NIL LOW MODERATE
Low LOW MODERATE HIGH
Moderate MODERATE HIGH VERY HIGH
Significant HIGH VERY HIGH EXTREME

So for example if the Impact Degree is Low and the % Impacted is 10% then
the value I want returned is HIGH.

I am currently using IF formulas adn trying to nest these without success.
I know that there are maybe lookup formulas I can use but this seems a bit
beyond me as I do not know how to reference the above table if in a different
worksheet but in the same workbook.

Thanks
Dave