Forum Discussion
Solved
vlookup works online not in Excel software
vlookup formula works on the Excel Web App but not on the installed Excel software. We reinstalled Microsoft 365 but still not allowing me to use vlookup or hlookup formulas. Getting the following...
If you're on Windows:
- Press Windows key+R to activate the Run dialog.
- Type control international and press Enter or click OK.
- In the Region control panel, click Additional settings...
- I suspect that List separator has been set to |
- Change it to a comma.
- Warning: it should not be the same as the Decimal symbol!
Continuuing on HansVogelaar 's line of thought, I think you may want to check your default list separator.
Formula errors when list separator is not set correctly - Office | Microsoft Docs
- It looks like it works if I use "|" in the formula when it should be "," Not sure where to change that?
If you're on Windows:
- Press Windows key+R to activate the Run dialog.
- Type control international and press Enter or click OK.
- In the Region control panel, click Additional settings...
- I suspect that List separator has been set to |
- Change it to a comma.
- Warning: it should not be the same as the Decimal symbol!
- Thank you so much!!