I have a sheet that I want to have link to the cell within the same sheet.
I want to link the following Phone names to the second image cell.
https://i.imgur.com/4ovzMpL.jpg
https://i.imgur.com/lWfbJ6z.jpg
Above is list of phones
I read this and attempted it but this did not work for me.
=HYPERLINK("#MyRange","Shift to there")
My formula in cell M2
=INDEX($C$2:$C$70,MATCH(N2,$I$2:$I$70,0))
And this
=HYPERLINK(VLOOKUP(M2,'Copy of Phones DP'!phones,1,0),M2)
This one links me to a new tab and searches for the following
http://galaxy%20s9+%2064gb/
The expected outcome would be When i click on the phone name in column M it goes to the phone row in column C
Bookmarks