Hi, 

I have created a spreadsheet to map data flow for my company and assign a scoring of 1 – 3 for four categories.

I have a list of a risk ratings based on the 4 scores given. 

The scoring looks like this on the main tab. I’ve added a section at the bottom of the first line to input the risk rating (which I’ll replicate when I’ve figured it out how to do it). I want it to pull the rating from the list based on the 4 scores given. 

so for the first entry from G8 the example above the risk rating will be ‘Low’. as it would flow 3,3,3,1. which is the third sequence on the left hand list on the snip above. 

I assume this would be easier if the risk rating list was in the same format as the scoring table on the main tab but I couldn’t work it out when I changed the list. 

any help would be appreciated and apologies if my query is not clear. 

​Hi,  I have created a spreadsheet to map data flow for my company and assign a scoring of 1 – 3 for four categories. I have a list of a risk ratings based on the 4 scores given. The scoring looks like this on the main tab. I’ve added a section at the bottom of the first line to input the risk rating (which I’ll replicate when I’ve figured it out how to do it). I want it to pull the rating from the list based on the 4 scores given.  so for the first entry from G8 the example above the risk rating will be ‘Low’. as it would flow 3,3,3,1. which is the third sequence on the left hand list on the snip above.  I assume this would be easier if the risk rating list was in the same format as the scoring table on the main tab but I couldn’t work it out when I changed the list.  any help would be appreciated and apologies if my query is not clear.   Read More

​