ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   IFERROR function with Hyperlink (https://www.excelbanter.com/excel-worksheet-functions/450893-iferror-function-hyperlink.html)

[email protected]

IFERROR function with Hyperlink
 
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"))


All times are GMT +1. The time now is 03:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com