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
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies