Translation of MATCH-function to Dutch version of Excel gives error when editing formula

Hi all,

I have a problem with the MATCH-function. I've made the workbook in an English version of Excel which is working fine. However if I edit the file in a Dutch version and I want to edit the formula (F2), it gives me a generalerror that the formula is not correct.
Anyone has an idea how to solve it (our company uses the Dutch version only).

I use this function for filtering on a search term in one of more columns.
The formula is: =IF(ISERROR(MATCH(SEARCH_FIELD;A6:AS6;0));0;1)
Search_Field is a named range for cell AH2 which can contain the search term.

In Dutch version the formula is: =ALS(ISFOUT(VERGELIJKEN(SEARCH_FIELD|A6:AS6|0))|0|1)
If I change the Search_field to a fixes cell(AH2) it is OK but I want it to be dynamic.

test.xls

Thanks for your help

HI Sixthsense,
The name stays identical to the English version in formula as well in the named range CTRL-F3.

Hi, it's not working. I created a new name 'test' but putting it in the Dutch formule still results in an error. It seems the Dutch MATCH-function (vergelijken) doesn't accept a named range!?

So it's Excel, not the user