I am trying to create an array formula that uses the HYPERLINK function to build friendly links to web pages.
Here, wiki is a name whose value is a string that contains the web link minus the final page name. But it makes no difference if I instead use the literal string.
See the attached workbook.
The formula works fine if I don't pass the second parameter (the friendly link string). It also works fine if I don't use it as an array formula:
Am I doing something wrong? I'm fairly certain that you can use two arrays in one formula so long as they are shaped the same.
Bookmarks