Advanced Conditional Hyperlink Help!

Highlighted
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
Highlighted

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.