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: =FI...
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.
