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...