You are welcome, I hope it may be adapted to your needs

I saw another post from you about this and additional link to the file. If
this works, and you get in a line the client name in a cell and the number in
the other, and they are related to the pdf file (for example, a folder for
the client and the number for the name of the pdf) you can use the HYPERLINK
formula. For example:
=HYPERLINK("file://C:\folder\" & A1 & "\" & B1 & ".pdf")
You need to change the folder and the references to match your specific
layout, but it may do what you needed.

Miguel.


"Penny" wrote:

I'm trying this now Miguel. Thanks so much for your time.

"Miguel Zapico" wrote:

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.