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
Bookmarks