Excel formulae not working

[Bindusitaram]

Getting this error when any formulae which needs to be linked to multiple cells are typed. E.g. Vlookup, Concatenate.

[#2]

You need to show us what you have in the formula bar.

[#3]

trying to perform vlookup or concatenation. it does not work and gives the above error

[#4]

@Doug_Robbins_Word_MVP 

[#5]

The formula is incomplete. See:
https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1

[#6]

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

[#7]

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.

[#8 · Accepted solution]

@Doug_Robbins_Word_MVP You are awesome. it worked. thanks a lot.