Hi All,
I'm having an issue with an excel INDEX and MATCH formula for the risk matrix below.
The formula I've used is:
=IFERROR(INDEX('OHS Risk Matrix'!$C$4:$G$8,MATCH(C24,'OHS Risk Matrix'!$C$3:$G$3,0),MATCH(B24,'OHS Risk Matrix'!$B$4:$B$8,0)),"")
It looks like it worked perfectly, however...