Vlookup not working in 2000 - worked in 97!

R

robingSA

Hi all,

I have a colleague who's comp had Excel 97. It now has Excel 2000 and
the vlookup formula is not working, despite having been created
originally in the older version. Even if one enters a new, valid
formula, it says that there is an error with the formula) Any ideas on
why this is happening?

Thanks

Rob
 
B

Barb Reinhardt

Why don't you check to see if values that you think are supposed to match
really do. It's possible that a number is formatted as text on one sheet
and number on another, and they won't match.
 
R

robingSA

As a follow-up to my first post...I have since played around with the
file a bit more and have found the following:

1 - In formulas normally requiring commas (such as VLOOKUP or SUMIF),
the commas have been replaced with spaces.
2 - If one tries to enter a new formula (one that requires more than
one "part") an error is returned - "You have entered too few arguments
for this function....")
3 - I even tried a simple formula using =SUM(A1,A2,A3) and it gave the
same error. If I use spaces instead of the commas, I got #NULL!!

What is going on here??? Is it best to re-install Office 2000? The
same file works fine on other machines using 97 or 2000.

Thanks
 
R

robingSA

Okay - I've got the answer! The list separator under Regional Settings
/ Numbers was set as a space instead of a comma!

Changed that and problem is solved!
 
Top