View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
McNic McNic is offline
external usenet poster
 
Posts: 3
Default 3 text lookup tables use to define contents of a cell

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