Hi All,
Hope everyone had a great New Years! I am looking for a bit of help in setting up a loop. Attached is a sample .xlsx in which my goal is to automate the result so that it is one of the following : Negligible, Low, Medium, High, Very High.
Currently I set up a table in columns S:V in which has all the possible scenarios (1 severity, 1 occurence = Low) etc.
What I would like to do is that based on the values placed in F & H, I would like it to automatically produce 1 of the 5 options I noted above (Neg, Low, Med, High, Very High) in column K.
Would anyone be able to assist me in creating a loop as I'm guessing this is probably the most effecient way of handling this?
Thanks!