I am trying to use nested IF and lookup commands to create multiple outputs from a series of 3 drop down menus. For example: If drop down menu options are A, B, and C then the result will be 0.1 but if it's A, C, C, then the result will be 0. It's sort of a calculation chart/generator type thing.
Solved by Z. A. in 15 mins