Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I'm trying to use the IFERROR function with hyperlink functions. I want the worksheet function to work like this: IF the hyperlink to the specific Device page returns an 'Unable to open' error message, then I want it to open the Main Page (which will always open). But, the worksheet function below continues to return the error message and doesn't open the Main Page. Am I doing something wrong, or can this function not be used this way? If not, are there any suggestions for how to make this work? Thanks! IFERROR(Hyperlink(E32,"Device"),Hyperlink(E31,"Mai n Page")) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
function =IFERROR LOOKUP works in excel 2007 not in excel 2003 | Excel Worksheet Functions | |||
iferror | Excel Worksheet Functions | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) |