The HYPERLINK function has an annoying problem

Wouldn’t it be great if the HYPERLINK function was fully compatible with dynamic arrays?

Here’s the function’s syntax:

HYPERLINK(link_location, [friendly_name])

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?