View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marc B. Marc B. is offline
external usenet poster
 
Posts: 1
Default Formula calculation

I am trying to calculate a column using the VLOOKUP function. When I enter
all of the variables, the function wizard shows the right results, but when I
hit enter to go to the next line, the forumla shows in the cell, not the
results I just saw in the wizard. I am also having a problem with the same
spreadsheet tyring to change a forumla that was working fine earlier, but now
does the same thing as the problem described above. I change the formula,
but when i go to save it, it just shows the forumula , not the results.