Google Sheets VLOOKUP returning Syntax Analysis Error

Question

Please take a look at the image. I am just testing to lookup for UID "20" and return it's value (which is 20..) but no matter my tests it is always returning Syntax analysis ERROR.

You can see with the orange marking that the range is selected correctly, the "20" is present in the UID but yet "ERROR" displayed. I'm picking up the 1st column from the VLOOKUP.

Why is that?

Thanks

Answer 1

If your spreadsheet is set to a locale (File > Settings > Locale) that uses commas as decimal separators, you have to separate the arguments with a semicolon, try:

=VLOOKUP(20; A2:B33; 2; FALSE)