Forum Discussion
Excel search box not returning hyperlink
Hi All,
Need help to show the hyperlinks when using the search function on my spreadsheet. I followed a tutorial to create a search box on excel using the 'Filter' Function. using this formula:
=FILTER(Table1,ISNUMBER(SEARCH(B4,Table1[Supplier]))+ISNUMBER(SEARCH(B4,Table1[Range]))+ISNUMBER(SEARCH(B4,Table1[Supplier Colour])),"No Match")
Column B shows uses the Hyperlink function so products can be quickly viewed. However when using the search box on the search on the other sheet the results the hyperlinks are not preserved
Is there a way to preserve the hyperlinks when using the search box
any help will be greatly appreciated
Thanks
5 Replies
That is the way formulas work - they return only the values of cells, not their formatting or hyperlinks. I don't think there is an easy workaround.
Ah thats a shame, I was really hoping there would be a workaround for this. Thanks for your help anyways.
There is what I consider a simple workaround. It involves separating the URLs from the friendly names, and using formulas to reconstruct the hyperlinks where needed/desired (including the Range column in Table1).
See the attached workbook.
Have you tried using slicer?
I haven't, can you explain on how this would work?
