When you say the text should change do you mean text in inverted commas?
Or do you mean if a formula is INDEX(MATCH(...
and German is selected then the formula should change to whatever the German Excel equivalent of INDEX(MATCH... is ?
Some info here...
http://www.excelforum.com/excel-gene...ish-excel.html
Bookmarks