VLOOKUP formula with different language

VLOOKUP formula with different language

Posted by: gm on 18 July 2018, 7:33 pm EST

• 

  gm

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 18 July 2018, 7:33 pm EST

  Syntax
  
  VLOOKUP(value,array,colindex,approx)
  
  Examples
  
  VLOOKUP(2,A1:D10,3)

  In the help of formulas I can see that the separator of arguments is only comma (“,”). This is OK when the PC has Operating System in English language. When I install my package in a PC with OS in Italian language, the formula rises up an error. So with Italian language the argument separator is no more comma “,”, but semi column (“;”). Do you know if it is the only exception or we have to expect more for different languages? I there any way to work around without check the culture at any time?

  VLOOKUP(F42,B2:C9999,2,1) ENG OS
  
  VLOOKUP(F42;B2:C9999;2;1) ITA OS

  Many thanks
  
  Giovanni

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 19 July 2018, 10:49 pm EST

  Hello Giovanni,

  This is correct behavior. On Italian OS the formulas are in accordance with the regional settings.
  
  Each countries have their own list separator symbol, separator symbol and decimal symbol and because the culture, which you are using, uses “;” for separator symbol. This is why it made the formula with “,” not working. The formulas are needed to be set according to the culture settings.
  
  The formula needs to be updated as per the regional settings.

  Thanks,
  
  Deepak Sharma