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?