Trying to work out a formula with cascading If statements. In cells B10:B13, copy vlaues from A1:E5 with the logic IF VALUE PRESENT IN Option 1, copy value in option 1, otherwise look in Option 2, otherwise Option 3 and Option 4. If no value present in any of the options, copy 0.
Solved by F. C. in 23 mins