If the ERROR.TYPE function in Excel is not working on your Windows 11/10 PC, this post will help you fix the issue. The ERROR.TYPE() function is one of the most useful functions for diagnosing ...

Value: Explanation: 0: Find an exact match; return #N/A if none found. This is the argument’s default value.-1: Find an exact match; return the next smaller item if no match is found.

If match_mode is not defined, the function will take its default value (0) and apply case sensitivity on the delimiter. So it won’t split the text, as shown in the above image. Example 5: Using ...