I agree with Fluff in that case. Add a sheet with a table of what outcomes should lead to what outcomes and do something like;
Below is the formula (return value & lookup table) that I'm using but, it returns a 0. I noticed in your suggestion you use VLOOKUP and INDEX. Is it possible to mix both of them?
Possible to do something more like this? Currently, returns #VALUE .