I had searched a searchable database in Excel for a long time. For example, I found this one which is quite useful:
www.thespreadsheetguru.com
What I found is that there are many ways to create a search box or search boxes with VBA or with Formula.
However, all of them return the data with text only. If the cell contains hyperlink, the return result only show its text without hyperlinks.
Does anyone know how to make a search box in Excel that can return result with hyperlinks?
4 PRO Ways to Create A Filtering Search Box [Excel Download]
Learn how you can use Excel formulas or VBA macro coding to create a search box that filters data based on a search term. The solutions we will create will allow for searching within multiple columns, performing partial match results, and knowing if you are looking for a numerical or textual value.
www.thespreadsheetguru.com
What I found is that there are many ways to create a search box or search boxes with VBA or with Formula.
However, all of them return the data with text only. If the cell contains hyperlink, the return result only show its text without hyperlinks.
Does anyone know how to make a search box in Excel that can return result with hyperlinks?
