<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - switch() gives "wrong data type" error on reordering value-result pairs" href="https://bugs.documentfoundation.org/show_bug.cgi?id=130583#c8">Comment # 8</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - switch() gives "wrong data type" error on reordering value-result pairs" href="https://bugs.documentfoundation.org/show_bug.cgi?id=130583">bug 130583</a> from <a class="email" href="mailto:dscheikey@gmail.com" title="Jürgen Kirsten <dscheikey@gmail.com>"> Jürgen Kirsten</a> <pre>Hello, everyone, I've been thinking very carefully. I have searched for the digit one in the column B (Value) in F8. Since there is no match here, the alternative value from cell C11 should actually be displayed. But it does not. We get a #VALUE error. The way Miguel changed the formulas, this is exactly the same as example 1, where I already mentioned that there are no problems with the first example. I don't understand the motivation why you changed my example. The function definitely does not work as expected. Best wishes and a happy Easter.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>