Hi all, new to the forum.

Wondered if someone could help me.

See workbook attached.

This is a new template for work that I am trying to automate as much as possible.

I am trying to populate the Control Determination cell based on the class table at the top.

This means I need to look at the Se cell (D15) and then compare the value in Cl (H15) against the class table.

I've tried a few things but am getting nowhere. An idea ive had is to give each cell in the table a value to then lookup from there. The stumbling block is that I'm looking for ranges of values, i.e. 3-4, 5-7, 14-15, etc.

Simply put if D15=4 and H15=6 then I15 should read "Action Required".

If D15=2 and H15=10 then I15 would read "None".

Thanks in advance.Risk Assessment Template.xls