 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2007Using HYPERLINK Function in array formula
I've spent a good part of the day working on a few pretty complex array formulas. I'd now like to add one that will create an array of hyperlinks. I thought I could do something equivalent to: =HYPERLINK({"http://google.com","http://yahoo.com","http:// microsoft.com"}, {"google","yahoo","microsoft"}) ...but I just end up with an array filled with google links... Anyone have any ideas? Thanks, James hi, James ! > I've spent a good part of the day working on a few pretty complex array formulas. > I'd now like to add one that will create an array of hyperlinks. > I thought I could do something equivalent to: > =HYPERLINK({"http://google.com","http://yahoo.com","http://microsoft.com"},{"google","yahoo","microsoft"}) > ...but I just end up with an array filled with google links... not an array formulae, but you need to point/index which address will be hyperlinked (i.e.) [A1] =hyperlink(index({http://google.com";"http://yahoo.com;"http://microsoft.com"},row()),index({"google";"yahoo";"microsoft"},row())) copy-down n_links hth, hector. On Nov 10, 2:23 pm, "H?ctor Miguel" <NOhemiordiS...@PLShotmail.com> wrote: > hi, James ! > [quoted text clipped - 12 lines] > hth, > hector. Thanks Hector! hi, James ! > Thanks ... thanks to you, I really appreciate your feed-back regards, hector. >> I've spent a good part of the day working on a few pretty complex array formulas. >> I'd now like to add one that will create an array of hyperlinks. [quoted text clipped - 5 lines] > [A1] =hyperlink(index({http://google.com";"http://yahoo.com;"http://microsoft.com"},row()),index({"google";"yahoo";"microsoft"},row())) > copy-down n_links
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.