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!
HansVogelaar I use the comma as I have done for the last 15+ years. When I copy an existing working formula into the cell it removes the commas and inserts blank spaces and will not work even with a copy and paste
What do you see in the formula bar when you download and open the attached sample workbook?
