Feb 11 2019 09:33 AM
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).
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!
Feb 11 2019 12:00 PM
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.