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
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.