Forum Discussion
Seemingly correct formula...incorrect?
Make sure that you use the correct separator between arguments of a function.
If you use point as decimal separator, use comma between arguments, for example
=VLOOKUP(A2,$F$2:$G$100,2,FALSE)
If you use comma as decimal separator, you should (probably) use semicolon between arguments, for example:
=VLOOKUP(A2;$F$2:$G$100;2;FALSE)
Make sure that you use the correct separator between arguments of a function.
If you use point as decimal separator, use comma between arguments, for example
=VLOOKUP(A2,$F$2:$G$100,2,FALSE)
If you use comma as decimal separator, you should (probably) use semicolon between arguments, for example:
=VLOOKUP(A2;$F$2:$G$100;2;FALSE)
- Thank you very much.
Replacing comma by semicolon worked well.
This brings me to another question..
I started learning how to use Excel very recently with an online training. In the video showed, everyone seems to be fine using comma in the same formula as mine. How come I have to use semicolon when they don't?It depends on your system settings. Most tutorial websites and training videos assume that you use a point as decimal separator: for example two-and-a-half is written as 2.5 as is usual in the USA and UK.
On such a system, you need to use a comma between function arguments.
But in many other countries, a comma is used as decimal separator, so that two-and-a-half is written as 2,5
In that case, you need to use a semicolon between function arguments.
