Forum Discussion

Bindusitaram's avatar
Bindusitaram
Copper Contributor
Jun 28, 2022
Solved

Excel formulae not working

Getting this error when any formulae which needs to be linked to multiple cells are typed. E.g. Vlookup, Concatenate.
Formulas and Functions
  • Bindusitaram's avatar
    Bindusitaram
    Copper Contributor
    Jun 28, 2022
    it does not let me complete the formula. that is the problem. lets say i am looking up a value from column A to column E. And then i type =vlookup(A2, E2 by the time i click on cell in column E i get an error posted above
    • Doug_Robbins_Word_MVP's avatar
      Doug_Robbins_Word_MVP
      MVP
      Jun 28, 2022
      Try using a semi-colon in place of the comma.
      It sounds like the list separator is set to a semi-colon under Windows>Settings>Additional date, time and regional settings>Region>Change date, time or number formats>Additional Settings>List Separator.

Resources