I am having a sheet in which I want to hyperlink a cell such that it finds text mentioned in formula and moves cursor there
For this I am using below formula
=HYPERLINK("#ToDo!A" & MATCH("promc1",A:A,0), "display text")
Above formula is entered in cell A53
Todo is sheet name in the same worksheet
promc1 is the text which need to be find
dislplay text is the text should be visible in A53
What is perfect: When i click link on A53, it will find promc1 in A and wherever it finds promc1 it will take the cursor there.
Problem is: instead of "display text" in A53 it shows zero
Attached screenshots
I am using MS Office 10 in windows 10
Please help in solving there
Bookmarks