Cell auto populates based on the answer in 4 other cells.

[JoeG2124]

[TABLE="width: 1083"]
<tbody>[TR]
[TD]Event Type
[/TD]
[TD]Risk Type
[/TD]
[TD]Financial Impact
[/TD]
[TD]Aged Days
[/TD]
[TD]Severity Rating
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Event Type
[/TD]
[TD][/TD]
[TD]Risk Type
[/TD]
[TD][/TD]
[TD]Aged Days
[/TD]
[TD][/TD]
[TD]Financial Impact
[/TD]
[/TR]
[TR]
[TD]Account Issue, Payments
[/TD]
[TD]Financial, Reputational, Operational
[/TD]
[TD]$1,000,001+
[/TD]
[TD]10
[/TD]
[TD]????
[/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD]Account Issue
[/TD]
[TD="align: right"]1
[/TD]
[TD]Financial
[/TD]
[TD="align: right"]1
[/TD]
[TD]0-15
[/TD]
[TD="align: right"]1
[/TD]
[TD]Less than $100,000
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD]Payments
[/TD]
[TD="align: right"]1
[/TD]
[TD]Reputational
[/TD]
[TD="align: right"]2
[/TD]
[TD]15-30
[/TD]
[TD="align: right"]2
[/TD]
[TD]$100,001 - $250,000
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD]Other
[/TD]
[TD="align: right"]1
[/TD]
[TD]Operational
[/TD]
[TD="align: right"]3
[/TD]
[TD]30-60
[/TD]
[TD="align: right"]3
[/TD]
[TD]$250,000 - $500,000
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD]Corp Event
[/TD]
[TD="align: right"]1
[/TD]
[TD]Other
[/TD]
[TD="align: right"]4
[/TD]
[TD]60-90
[/TD]
[TD="align: right"]4
[/TD]
[TD]$500,001 - $1,000,000
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1
[/TD]
[TD]Settlement
[/TD]
[TD="align: right"]1
[/TD]
[TD]Regulatory
[/TD]
[TD="align: right"]5
[/TD]
[TD]90+
[/TD]
[TD="align: right"]5
[/TD]
[TD]$1,000,001+
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 14"]I have a drop down list with multiple selections, is there any way to give each option a value? For instance above, in the first column, 2 things are selected, can I have that as a 2? Second column 3 things are selected so that would be a 3.
[/TD]
[/TR]
[TR]
[TD="colspan: 3"]Each of the first 2 drop downs have 5 choices.
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 11"]So, I would like the "severity rating" to automatically populate based on the answers in the 4 columns before it. Is the only way to do this with a macro?
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 14"]The numbers to the left of the list are the values I would give for each, so your highest "severity rating" score could be 20. Based on what I have in there now, the rating would be 11.
[/TD]
[/TR]
</tbody>[/TABLE]

 

[oldbrewer]

if the first line of the drop down were 1 account issue taking =left(a3,1)*1 would return numeric 1 which can be added to other selections using the same methodology