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.
1 Reply
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.
