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.

wrote in message
oups.com...
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