Hi - I'm a new member to this forum. I'm trying to come up with a UDF that will take two inputs representing four ranges each and look up the intersecting value. Specifically, I have four sets of probabilities and four sets of severities (impacts), and for each combination there is a defined Action. Picture a matrix with the 4 probability ranges on the Y Axis and the 4 Impact ranges on the X axis. I think I'm close but I just cannot get this function to work. Any help is much appreciated.
Here's the matrix and the code I have so far:
>70% Action 1 Action 3 Action 4 Action 4
>40 to <70% Action 1 Action 2 Action 3 Action 4
>10 to <40% Action 1 Action 2 Action 3 Action 3
0 to <10% Action 1 Action 1 Action 2 Action 2
0 to ≤7 >7 to ≤14 >14 to ≤24 >24
Bookmarks