Hi pkeegs,

It could be useful to see an example of the formula that doesn't work, the
data used, the error message or the incorrect value and the desired value.

Regards,
KL


"pkeegs" wrote in message
...
I have a list in Excel that is reasonably long, VLOOKUP won't pick up some
of
the end items. If I move the reference up the list it will work. However
if I
leave it at the end and remove a large middle section of the list, it will
still not work. All formulae have been copied, I have reformatted all the
cells the same, names (database) in the formula have a big enough
reference.
Any suggestions?