Forum Discussion
Hyperlink doesn't stay in the same row as the data in my Table
I made a worksheet with Dynamic search box using FILTER function and made another worksheet that has the Masterlist, i need to hyperlink Certificate records of the hospital staff the Table but when i...
Try to combine the HYPERLINK function with the FILTER function. Instead of directly hyperlinking the Certificate records in the Masterlist:
=HYPERLINK("FilePathOrURL", Masterlist!CellReference)
Where:
- "FilePathOrURL" is the URL or file path of the certificate.
- Masterlist!CellReference refers to the cell with the relevant staff name or data.
Expect the hyperlink should appear dynamically in your search results based on the filtered data.