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 it explains that putting the = indicates a formula and suggests putting a ' before and treating it like text. I have tried this on a clean workbook and still the same issue. I use this formula often and not had this issue before.
5 Replies
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?
