vlookup with hyperlink in formula

[Gwynne]

I am trying to use the vlookup command (ie, =vlookup(a3,d3:d7,4) 4 linking to
a database that is hyperlinked to actual Word document forms. I want the
answer in the vlookup formula cell to be the hyperlinked document the user
can click on and fill out the apporpriate form. Any way to do that? Or, is
there a better way to do that?

Thanks,
Gwynne in Albuqueruqe

 

[Gary''s Student]

Say we have a lookup table in cols A & B with files and web sites:

1 http://www.cnn.com
2 file:///c:\temp\number.doc
3 http://www.fox.com


In E1 we put a number and in F1 we enter:

=HYPERLINK(VLOOKUP(E1,A1:B100,2,FALSE))

This will be a "hot" link to the file or site.

 

[Gwynne]

Thanks Gary, I entered =HYPERLINK(VLOOKUP(B2,FormsList!A2:B51,2)). it
displays the proper hyperlink document; however when I click on it is gives
me "Cannot open specified file". When I go the the FormsList sheet the
document is hyperlinked to the correct form the hyperlink works correctly.
Just the hyperlinked document displayed in the =HYPERLINK... formula displays
the correct document just an error occurs when I try to click to open the
hyperlink. Does that make sense?

 

[Gary''s Student]

What you say makes sense, but I don't understand what is wrong.