Hi, Penny-
I started working on a solution for you and got sidetracked (my boss is
so impetuous that way). Your earlier post said you're working with
Bates numbering- are your document numbers contiguous, or do they have
gaps? Also, by any chance are the documents related to a client
entered as two numbers in two cells (the lowest document number and the
highest document number), or are they entered in a single cell in the
format 12003-12212?

More globally speaking, do you have the latitude within your
organization to re-arrange the data if you need to, in order to make
this lookup idea possible?

DaveO