Aug 31 2022 02:12 PM
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 error. I have been a user for 20+ years.
Aug 31 2022 02:39 PM
Does the locally installed version use comma as decimal separator? If so, use semicolon ; in the formula:
=VLOOKUP(C576; B567:C568; 2; FALSE)
Aug 31 2022 03:19 PM
Aug 31 2022 03:32 PM
Continuuing on @Hans Vogelaar '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
Aug 31 2022 05:54 PM
Sep 01 2022 12:31 AM
SolutionIf you're on Windows:
Sep 01 2022 12:31 AM
SolutionIf you're on Windows: