Forum Discussion
AlexRabiller42
Apr 23, 2021Copper Contributor
Vlookup formula
Hello Community, When I am trying to enter a Vlook up formula as follows =vlookup(cell, and trying to enter the array I am getting the following error message as per attached. No matter what spr...
HansVogelaar
Apr 23, 2021MVP
AlexRabiller42 Do you use comma as decimal separator? If so, use semi-colon between the arguments of a function:
=VLOOKUP(A39; ...
AlexRabiller42
Apr 23, 2021Copper Contributor
HansVogelaar Yes you are right, I am actually using a French language on the qwerty keyboard and I didn't realise I had to use a coma instead of a semi-colon between the arguments.
Thanks a lot for your quick revert on the matter.
Thanks a lot for your quick revert on the matter.
- AlexRabiller42Apr 23, 2021Copper Contributor*I meant had to use a semi-colon instead of a coma 🙂