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!
