CODEWITHSUNDEEP
excelsearchcommentsdisplaysearchbar
Florent
Florent

Reputation: 17

VBA - Search & Display : result doesn't take comment/URL into account

I've been working on a dynamic search bar in Excel, following this video, and it works fine.

=IF(I3="","No match",FILTER(Table1,ISNUMBER(SEARCH(I3,Table1[Sujet])),"No match"))

However, it doesn't display meta info from the cell (comment, URL...) meant to make the result a bit more interactive. In the attached image, looking for "machine" will display the cell that is containing such additional info, but no active Link, nor a Comment icon.

[Exemple](https://i.sstatic.net/fzMSwwu6.png)

Is it an option I'm overlooking, or a limitation ?

I know even less about Excel and its formulas than VBA... The formula came from this video : https://www.youtube.com/watch?v=a4WbzvYwAUI but there's no comments, and the file provided isn't even complete !

Upvotes: 0

Views: 43

Answers (0)

Related Questions