Hyperlink cell based on value

[hgbegdhegdh]

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 this

screenshot at below link
https://my.pcloud.com/publink/show?code=XZSn94kZDUP9V6pN0LbUHNrn89Oj5kjXBVKy


Also posted here
https://www.excelforum.com/excel-fo...yperlink-cell-based-on-value.html#post5211705

 

[Fluff]

Try moving the formula to another column, maybe B53.
With the formula in col A you will get a circular reference, which is probably causing the problem.

 

[hgbegdhegdh]

Genius. This solved the issue

 

[Fluff]

You're welcome & thanks for the feedback