I suspect the last parameter in your VLOOKUP function. It should be set to
false if you want only exact matches.

Check Help for descriptions of the parameters. If the last one is omitted
then it defaults to True and If an exact match is not found, the next largest
value that is less than lookup_value is returned.

If this doesn't answer your question then please post a copy of your
formula. (Highlight it in the formula bar and copy. Press Enter and then
paste it into this post.)

Regards,

OssieMac

"POD27" wrote:

I have a very simple table of cost centre numbers and associated cost centre
names in the next column.
This table in a spreadsheet worksheet, links directly to our accounts package
through a template function supplied our accounts package supplier. This
table is fine.

V lookup is used in other workbooks to put the name in the next cell to the
cost centre number.
Vlookup will work, up to a certain cost centre number, but then, for no
apparent reason will displace the names by one line number. therefore, after
Cost centre 500, the name that applies to cost centre 490, the cost centre
immediately preceeding 500, appears in the adjacent cell, where you would
expect the name for CC500 to appear.

These lookups all worked fine, until I loaded Office 2003 SP 3 when the
problems started.