Wouldn’t it be great if the HYPERLINK function was 𝘧𝘶𝘭𝘭𝘺 compatible with dynamic arrays?
Here’s the function’s syntax:
I have a table called tblWebsites featuring three websites, each with its name and URL.
In D2, if I were to reference just the URL column in the compulsory
link_location argument, it would return the URLs in a spilled range.
However, including the Website column in the optional
[friendly_name] as well does not produce the intended result.
Instead of returning ‘Bing’, ‘Google’ and ‘Yahoo’, it returns three ‘Bing’ values, with only the first underlined in blue. The links do not all point to Bing, though.
Nevertheless, is anyone else annoyed by this?