Clickable on Filter Formula

[dannwid]

Hi colleagues,

I'm having lil bit issue with my Filter formula. So, basically I have 1 master data for scoring and in other hand i need to disclose some certain range that meets some condition. Have a look in uploaded pic.

On the left table is the master data, on the right I disclosed some with condition (disclose only person with 60 or less in score). In master table you see that it has hyperlink directing to its document location (each "to docs" is hyperlink-ed with its url in column D).

What i am asking: is there any possible way to keep its hyperlink alive on the right table (filter formula).
It would be better if there are no macros involved

Should you need the file: https://www.file.io/ul80/download/C35Qm7nOdkJX

Thanks in advance.

 

[Peter_SSs]

Should you need the file: https://www.file.io/ul80/download/C35Qm7nOdkJX

When clicking that link ..

 

[dannwid]

When clicking that link ..

View attachment 118093

Try this:

Loading Google Sheets

 

[Peter_SSs]

Thanks. Perhaps somebody else can, but I was unable to get the hyperlinks to work correctly within a spilled array but wondering if this workaround would suffice if nothing better comes along?
BTW, there is no need for the IFERROR as the FILTER function has an option argument for what to do if the filter returns nothing.

In H5

=FILTER($A$5:$B$10,$B$5:$B$10<=K2,"")

In J5 (then copy down to J10)

=IF(I5="","",HYPERLINK(FILTER(D$5:D$10,(A$5:A$10=H5)*(B$5:B$10=I5)),"To Docs"))

 

[dannwid]

Thanks. Perhaps somebody else can, but I was unable to get the hyperlinks to work correctly within a spilled array but wondering if this workaround would suffice if nothing better comes along?
BTW, there is no need for the IFERROR as the FILTER function has an option argument for what to do if the filter returns nothing.

In H5

=FILTER($A$5:$B$10,$B$5:$B$10<=K2,"")

In J5 (then copy down to J10)

=IF(I5="","",HYPERLINK(FILTER(D$5:D$10,(A$5:A$10=H5)*(B$5:B$10=I5)),"To Docs"))

Thank you,
I also have an issue with link on spilled array.
However, i think your formula works fine.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.