How to convert list separator in formula with strings according to locale

I have a workbook with several formulas like the following one:

Please Login or Register  to view this content.

My problem is that when opening the excel file from a system using a different locale - and more specifically different list separators (";" instead of ",") the commas inside

Please Login or Register  to view this content.

are not converted, since they are considered as strings. All the other commas, however, are converted, so the formula results in #REF! error.

How could I get excel to treat those "," as list separators, and thus convert them too to ";"? Is there some sort of generic reference to list separator, which I could use instead of the comma inside those strings?

Originally Posted by rorya

Why do you want to include the header row as a matter of interest? Doesn't usually make sense in a MATCH formula.

B34 contains the name of a table on another sheet (="getDataM"). So with

Please Login or Register  to view this content.

I am referring to the LOOKUP column of that table, which contains a code I want to match. There are many tables on the same sheet with a column named LOOKUP, and there is the risk that a code might not be unique outside of each table, hence I wrote the formula this way. Would there be a better way to do this?