Variabel text in MID. VLOOKUP?

I am not sure where to swap ";" and "," for regional settings. This formula is the American version. The file is attached. Hopefully your settings will correct.

Formula:

=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(INDEX($C$3:$E$4,MATCH(1,MMULT(--ISNUMBER(SEARCH(A1,C3:E4)),

ROW(INDIRECT("1:"&COLUMNS($C$3:$E$4)))^0),0),MATCH(1,MMULT(COLUMN(INDEX(1:1,1):INDEX(1:1,ROWS($C$3:$E$4)))^0,

--ISNUMBER(SEARCH(A1,C3:E4))),0)),A1,""),"(",""),")",""))