Hi,
I’m trying to make the Switch function to work, and I need help to understand what I have done wrong.
Here it is the following sheet
In D20, there is the following formula =SWITCH(D18,C1:C13,D1:D13)
I don’t understand why there is a #VALUE displayed in D20, and it’s still displayed if I put ’ 01 - SOME STUFF’ in D18.