Forum Discussion
ERROR USING VLOOKUP FORMULA
Hello, For 2 days now I am unable to use the VLOOKUP formula. Here is the syntax I am using =vlookup(A3,newclient,1,false) Error - There is a problem with this formula No reason but i...
Do you use comma as decimal separator? If so, you should use semi-colon to separate the arguments of the function:
=vlookup(A3;newclient;1;false)
HansVogelaar Thank you, have found out what the problem is. Since the last update from Microsoft the list separator under Region settings keeps resetting itself to a space, sometimes several times a day.
What a weird problem!