| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel if & hyperlink formula
Hi
maybe try something like =IF(K2=1,HYPERLINK(A1),"") -- Regards Frank Kabel Frankfurt, Germany LLee wrote: Hello. I have a formula that I need to cross reference an if statement and if it is true, pull forward the hyperlink that is in the appropriate cell. I can get it to pull the actual text, but I have not found out a way to get it to pull forward the active hyperlink. Here's what I have: =if(K2=1,A2,false) Columns K - . . . are various sorted departments and designate if that particular policy is applicable for that department. We want to create a customized Table of contents for our Policy Manual based on if the policy applies to that department. The hyperlinks are word documents on our public drives accessible by everyone. If anyone can help I'd really appreciate it. Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel if & hyperlink formula
Hi
whyt value is exactly in cell A1 -- Regards Frank Kabel Frankfurt, Germany LLee wrote: Thanks Frank. It worked, however, its isn't finding appropriate file. "Cannot open specified file." So I will have to keep at it. Thanks again "Frank Kabel" wrote: Hi maybe try something like =IF(K2=1,HYPERLINK(A1),"") -- Regards Frank Kabel Frankfurt, Germany LLee wrote: Hello. I have a formula that I need to cross reference an if statement and if it is true, pull forward the hyperlink that is in the appropriate cell. I can get it to pull the actual text, but I have not found out a way to get it to pull forward the active hyperlink. Here's what I have: =if(K2=1,A2,false) Columns K - . . . are various sorted departments and designate if that particular policy is applicable for that department. We want to create a customized Table of contents for our Policy Manual based on if the policy applies to that department. The hyperlinks are word documents on our public drives accessible by everyone. If anyone can help I'd really appreciate it. Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel if & hyperlink formula
some example of use of HYPERLINK Worksheet Formula
http://www.mvps.org/dmcritchie/excel....htm#hyperlink --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "LLee" wrote in message ... Thanks Frank. It worked, however, its isn't finding appropriate file. "Cannot open specified file." So I will have to keep at it. Thanks again "Frank Kabel" wrote: Hi maybe try something like =IF(K2=1,HYPERLINK(A1),"") -- Regards Frank Kabel Frankfurt, Germany LLee wrote: Hello. I have a formula that I need to cross reference an if statement and if it is true, pull forward the hyperlink that is in the appropriate cell. I can get it to pull the actual text, but I have not found out a way to get it to pull forward the active hyperlink. Here's what I have: =if(K2=1,A2,false) Columns K - . . . are various sorted departments and designate if that particular policy is applicable for that department. We want to create a customized Table of contents for our Policy Manual based on if the policy applies to that department. The hyperlinks are word documents on our public drives accessible by everyone. If anyone can help I'd really appreciate it. Thanks! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel if & hyperlink formula
It is a hyperlink to a word document within the same drive and actually the same folder as well.
"Frank Kabel" wrote: Hi whyt value is exactly in cell A1 -- Regards Frank Kabel Frankfurt, Germany LLee wrote: Thanks Frank. It worked, however, its isn't finding appropriate file. "Cannot open specified file." So I will have to keep at it. Thanks again "Frank Kabel" wrote: Hi maybe try something like =IF(K2=1,HYPERLINK(A1),"") -- Regards Frank Kabel Frankfurt, Germany LLee wrote: Hello. I have a formula that I need to cross reference an if statement and if it is true, pull forward the hyperlink that is in the appropriate cell. I can get it to pull the actual text, but I have not found out a way to get it to pull forward the active hyperlink. Here's what I have: =if(K2=1,A2,false) Columns K - . . . are various sorted departments and designate if that particular policy is applicable for that department. We want to create a customized Table of contents for our Policy Manual based on if the policy applies to that department. The hyperlinks are word documents on our public drives accessible by everyone. If anyone can help I'd really appreciate it. Thanks! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel if & hyperlink formula
Hi
then see David's response for some VBA code -- Regards Frank Kabel Frankfurt, Germany LLee wrote: It is a hyperlink to a word document within the same drive and actually the same folder as well. "Frank Kabel" wrote: Hi whyt value is exactly in cell A1 -- Regards Frank Kabel Frankfurt, Germany LLee wrote: Thanks Frank. It worked, however, its isn't finding appropriate file. "Cannot open specified file." So I will have to keep at it. Thanks again "Frank Kabel" wrote: Hi maybe try something like =IF(K2=1,HYPERLINK(A1),"") -- Regards Frank Kabel Frankfurt, Germany LLee wrote: Hello. I have a formula that I need to cross reference an if statement and if it is true, pull forward the hyperlink that is in the appropriate cell. I can get it to pull the actual text, but I have not found out a way to get it to pull forward the active hyperlink. Here's what I have: =if(K2=1,A2,false) Columns K - . . . are various sorted departments and designate if that particular policy is applicable for that department. We want to create a customized Table of contents for our Policy Manual based on if the policy applies to that department. The hyperlinks are word documents on our public drives accessible by everyone. If anyone can help I'd really appreciate it. Thanks! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel if & hyperlink formula
Thanks David - the site was very practical and I think it will do the trick!
Thanks again! "David McRitchie" wrote: some example of use of HYPERLINK Worksheet Formula http://www.mvps.org/dmcritchie/excel....htm#hyperlink --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "LLee" wrote in message ... Thanks Frank. It worked, however, its isn't finding appropriate file. "Cannot open specified file." So I will have to keep at it. Thanks again "Frank Kabel" wrote: Hi maybe try something like =IF(K2=1,HYPERLINK(A1),"") -- Regards Frank Kabel Frankfurt, Germany LLee wrote: Hello. I have a formula that I need to cross reference an if statement and if it is true, pull forward the hyperlink that is in the appropriate cell. I can get it to pull the actual text, but I have not found out a way to get it to pull forward the active hyperlink. Here's what I have: =if(K2=1,A2,false) Columns K - . . . are various sorted departments and designate if that particular policy is applicable for that department. We want to create a customized Table of contents for our Policy Manual based on if the policy applies to that department. The hyperlinks are word documents on our public drives accessible by everyone. If anyone can help I'd really appreciate it. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hyperlink formula | Excel Worksheet Functions | |||
| Hyperlink formula | Excel Worksheet Functions | |||
| Hyperlink Formula | Excel Discussion (Misc queries) | |||
| Excel, turn off the hyperlink format when formula is @sum | Excel Worksheet Functions | |||
| Can someone fix this hyperlink formula? | Excel Programming | |||
Linear Mode
