Using english and non-English Excel commands simultaneously in a non-English installation

Using english and non-English Excel commands simultaneously in a non-English installation

Post by Michael.Ta » Fri, 12 Mar 2010 19:29:37


Hi community,
I like this forum very much - I got many valuable insights from it. In
the past I had an English Excel installation at the office available,
recently my employer moved to the German version and deinstalled the
english one.
Now, when i use a english command like =VLOOKUP(A1,'Sheet 2'!
A1:H200,8,FALSE) adopting the country settings for "," with ";" Excel
comes up with #NAME? since I used the english term, not the german one
- but sometimes the german equivalent is not at hand as fast as
needed ;-)

However if a open a english coined workbook of a US/UK colleague with
a built-in commands in English, the german Excel instllation is able
to translate.
So, is there a kind of Addin or multi-language extension available to
use english and non-english built-in commands in a non-English
installation simultaneously?

Thks for any help, have a great day
Michael
 
 
 

Using english and non-English Excel commands simultaneously in a non-English installation

Post by Bob Philli » Fri, 12 Mar 2010 20:45:47

See my response in worksheetfunctions.

--

HTH

Bob