Forum Discussion
Excel FILTER function to return hyperlinks
Hello,
I'm trying to create a tool that allows users to type in their company name, and it will return a link to which they can click on and navigate to.
I used the FILTER function, but notice that when the values are returned, the links are no longer there.
I think the problem is that FILTER function doesn't seem to return links. Is there a way around this?
I included a workbook here, and the first tab is the tab where users type in company A, B or C and the FILTER function returns the company name and a link. but the link doesn't seem to include anything when returned.
thanks!
I'm afraid there is no workaround at the moment. The FILTER function only returns the value of the filtered cells, not any hyperlinks in those cells.
See Makeing a filter with hyperlink and can't press the hyperlink. (Sadly, Excel UserVoice has been discontinued since then)
9 Replies
I'm afraid there is no workaround at the moment. The FILTER function only returns the value of the filtered cells, not any hyperlinks in those cells.
See Makeing a filter with hyperlink and can't press the hyperlink. (Sadly, Excel UserVoice has been discontinued since then)