Forum Discussion

PBIguy's avatar
PBIguy
Copper Contributor
Oct 18, 2021
Solved

Excel FILTER function to return hyperlinks

Hello,

 

I'm trying to create a tool that allows users to type in their company name, and it will return a link to which they can click on and navigate to.

 

I used the FILTER function, but notice that when the values are returned, the links are no longer there.

 

I think the problem is that FILTER function doesn't seem to return links. Is there a way around this?

 

I included a workbook here, and the first tab is the tab where users type in company A, B or C and the FILTER function returns the company name and a link. but the link doesn't seem to include anything when returned.

 

thanks!

9 Replies

Resources