vlookup with hyperlink in formula
 

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

vlookup with hyperlink in formula
 

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

vlookup with hyperlink in formula
 

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

vlookup with hyperlink in formula
 

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.

My formula should also work and it does on first try. When I protect the sheet (unlock the cell with the hyperlink), save the workbook, close it, open it again and click on the hyperlink I get the same error message and it doesn't work anymore.....