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

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.
--
Gary''s Student - gsnu200805


"Gwynne" wrote:

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

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" wrote:

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.
--
Gary''s Student - gsnu200805


"Gwynne" wrote:

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

What you say makes sense, but I don't understand what is wrong.
--
Gary''s Student - gsnu200805


"Gwynne" wrote:

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" wrote:

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.
--
Gary''s Student - gsnu200805


"Gwynne" wrote:

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

Was this ever solved, as I have exactly the same error and do not know how to solve it?

Tested a sample data and the formula is indeed correct.