Forum Discussion
Advanced Conditional Hyperlink Help!
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). ...
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.