McNic --
How about assigning numerical values to the first two tables, and
manipulating them somehow (multiplying or adding) to get a numerical risk
level. So the different 'likelihood' states get values 1-5 in order of
increasing likelihood, and the different 'consequences' states get the same.
Then you could either just multiply, or get fancy with nexted 'IF'
statements, a la:

A B C D E
1 Likelihood # Conseq. # Risk
2 Likely 4 Insignificant 1 see
formula below

E2 formula

=if(b2*d220,"Extreme",if(b2*d215,"High", etc etc

HTH

"McNic" wrote:

Hi I've 3 lookup tables that I want to use to define what the contents of a
ceel should be. Tables For example: I need to compare the 1st two tables to
automatically define the risk level contained in the 3rd table.
Likelihood Consequences Risk level
Almost certain Insignificant Low
Likely Minor Medium
Possible Moderate High
Unlikely Major Extreme
Rare Catastrophic
Any suggestions or help would be fantastic, thanks