Working with range of numbers in a cell and searching same
 

I have tried searching for the solution ... and I've had no luck. Thanks to
anyone that can help me. I really appreciate it.

I'm working with Bates Numbers on client documents. 15,000+ documents and
13+ different clients. Some clients have a range of documents (12003-12212)
I need to be able to search for document 12,198 and pull up the specific
client tied to that document number. An even sweeter addition to this would
be to then click on a link that opens the PDF file where the document is
stored.... but that's dreaming! :-)

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