Can't work out why I am getting an UNPARSEABLE error message please help

Paul Allen

All I need is the correct return according to the Probability and Impact criteria in screenshot 1 into my Risk log in screenshot 2

Screenshot 1

=INDEX(COLLECT({Risk Management Matrix Range 1}, {Risk Management Matrix Range 2}, Probability@row), {Risk Management Matrix Range 3},Impact@row),1)

Jeff Reisman

@Paul Allen Try these fixes:

Paul Allen

@Jeff Reisman thanks for getting back to me but still no joy :(

Just as a check and balance this is what I have now further to your advice but the #UNPARSEABLE error still remains

=INDEX(COLLECT({Risk Management Matrix Range 1}, {Risk Management Matrix Range 2}, Probability@row, {Risk Management Matrix Range 3}, Impact@row), 1))

...the quest continues

Paul Allen

@Jeff Reisman OK so I cleared all references from the scoring matrix and started agin and hey presto it worked so thank you so much.

Paul Allen

@Jeff Reisman OK so I cleared all references from the scoring matrix and started agin and hey presto it worked so thank you so much.

Paul Allen

@Jeff Reisman OK so I cleared all references from the scoring matrix and started agin and hey presto it worked so thank you so much.