You may use part of the example in
http://www.dailydoseofexcel.com/arch...iable-lookups/
for how to use VLOOKUP in a similar case (looking for data in ranges instead
of individual values)
Hope this helps,
Miguel.

"Penny" wrote:

I'm working with numbered documents. Some clients have a range of documents
(12003-12212) I want to search for document 12,198 and pull up the specific
client tied to that document number.

Know of any possible way to make this happen? Thanks again for your time
and assistance.