Microsoft Excel and Google Sheets

Question

The formula in Microsoft Excel is not any different than in the Google Sheets. But, I get different results

      (left) Microsoft Excel,              (right) Google Sheets

The Google Excel formula works; the same Google Sheets formula does not work in the Microsoft Excel one.

How can I fix this? Ignore the Dutch separator ; – in the English version with the separator , I have the same problem.

Answer 1

The problem on the Excel side is that you seem to be expecting SEARCH(range, value) to return an array, but, as far as I can tell from the question, you have not entered it as an array formula.  If you click in cell D2 and press Ctrl+Shift+Enter, your formula will work.