Hi Again,

I reloaded the the spreadsheet that the vlookup feeds off from a back up tape,
and this corrected things.

When I refreshed this table, that links into our accounts package through an
ODBC arrangment, the same problem was encountered. I assume therefore, the
underlying problem must be with data extracted from the accounts package,
which although it looks fine, creates a problem when interrogated through
vlookup.

I have contacted our accounts package dealers.

many thanks

OssieMac wrote:
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

I have a very simple table of cost centre numbers and associated cost centre
names in the next column.
[quoted text clipped - 12 lines]
These lookups all worked fine, until I loaded Office 2003 SP 3 when the
problems started.