I have written a Lookup formula to assign a risk to likelihood and consequence sores. But the results are back to front.
Refer attached file, in which formulas are in first sheet, and matrix is in 2nd sheet.
Can you help fix. Risk-Matrix-Lookup-Example.xlsx
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…