Forum Discussion
Excel FILTER function to return hyperlinks
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)
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)
That really sucks, It would be a great feature for the FILTER function.
Since you have the addresses within HYPERLINK formulas I believe there might be a workaround in this case using FORMULATEXT...
Hi Lori_m, I'm trying to implement your solution into my original function that looks like this: =FILTER(Data,ISNUMBER(SEARCH($B$3,Data[Employee ID2]))=TRUE,"Not match found"). I don't need the "Navigate to it" feature, I just need to get the results to come back with the hyperlink that's linkable. Right now the text comes back but it's just not linkable. I'm hoping to integrate your solution of using FORMULATEXT, is it possible to do this? Thank you for any help you could provide. - Milo
- nicely done lori_m
hope you don't mind I added it to my cheat-sheet of useful functions/formulasim having the exact same issue with my sheets. I've tried to use xlookup and vlookup to avail. Can you help me out?
This is My current formula.
I'd like it to return the hyperlinks in [#product numbers]
=FILTER(IF(ISBLANK(Table1), "", Table1),ISNUMBER(SEARCH(H2,Table1[[#Data],[Product Number]])) + ISNUMBER(SEARCH(H2,Table1[[#Data],[Product Name]])), "Nothing Found")
Any help is greatly appreciated 🙏
Great idea!
