Hyperlink support in Index/Match/Collect/etc. functions

Mark H

As other posts for help point out hyperlinks do not transfer when when using functions to look up hyperlink values. Please add support for looking up hyperlink values via formula such that the Display Text and URL transfer to the destination. See details in the links below.

The workaround of linking to a cell in another sheet containing a URL is extremely tedious when working with many rows.

The workaround of using URLs only with no friendly text is unprofessional and gives a poor user experience.

References:

• Index/Match function that transfers hyperlinks to another sheet
• Can I use a hyperlink in a formula?
• Hyperlink function

MarkCep

You should be able to copy a hyperlink (such as a link to another sheet) by way of a formula. Having to do each one separately is painful and time consuming.