Home

Advanced Conditional Hyperlink Help!

Shawn French
Occasional Contributor

In Cell O11, I want a hyperlink which will display the text "VID" and reference cell K11 to match the cell containing the same contents in sheet "New Exercise List" (seen in the second picture).

 

Screen Shot 2019-02-11 at 12.01.58 PM.png

Screen Shot 2019-02-11 at 12.02.49 PM.png

For example, I want O11 to display "VID", and when I click on it it will take me to B40 on the second worksheet as that cell contains 'Sumo Deadlift.' 

 

Thank you all for your help!


@Sergei Baklan 

1 Reply

Hello,

 

may I ask: why do you use so many merged cells? It makes life harder than it needs to be. 

 

Try this formula: 

 

=HYPERLINK("#Sheet2!B"&MATCH(B3,Sheet2!B:B,0),"Vid")

 

See attached.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies