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 put it on the row of someone specific the data becomes a plain text on my search box.
i tried also hyperlinking the file on the searchbox as well but the hyperlink stays on the same cell and doesn't follow the row it should be in.
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.
