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

M

Michael.Tarnowski

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using english and non-English Excel commands simultaneously in anon-English installation 6
Excel: Replace strings with a Matrix formula 6
Excel 2003 Visual Basic (List Box) in English not running in Germa 6
English date format and compatibilty with others Excel Language 1
HELP! Services in NON ENglish! 4
this formulas is in English ... what is it in German? 8
Fontstyle in Excel VBA is in local language. How to convert to English? 2
Language problems in Excel 2007 1

Top