LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 24th 15, 03:40 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
First recorded activity by ExcelBanter: May 2015
Posts: 13
Default IFERROR function with Hyperlink


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
function =IFERROR LOOKUP works in excel 2007 not in excel 2003 David Ryan Excel Worksheet Functions 4 April 15th 09 03:25 PM
iferror Roy Gudgeon[_2_] Excel Worksheet Functions 13 July 31st 08 05:24 PM
Can't make hyperlink function work for hyperlink to website Frank B Denman Excel Worksheet Functions 15 February 5th 07 11:01 PM
How do I create a hyperlink to a cell with the hyperlink function S. Bevins Excel Worksheet Functions 2 July 20th 06 08:06 PM
Intra-workbook hyperlink: macro/function to return to hyperlink ce marika1981 Excel Discussion (Misc queries) 3 May 6th 05 05:47 AM

All times are GMT +1. The time now is 04:31 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017