Please excuse this bummer from me - tried to reproduce the problem from the original worksheet and messed it up a bit...
Changed the Nein to No and Ja to Yes
Now there is the #VALUE again as you can see in the reworked attachment from Hans
Edit: Added numbers to the additional comments to make it clear as Ali suggested.
Bookmarks