hyperlink - Hyperlink to particular Text in a cell on the same sheet

Question

I'm working with Excel 2010. What I'm trying to accomplish is creating a hyperlink which finds a cell containing some specific text, and simply brings the user to that cell. It would be simple if the cell stayed in the same position in the column, but more data is always being added to that column, and the cell location which contains the text keeps changing.

Although I've seen several articles that I suspect might address the problem, they were so involved that I couldn't be certain they were what I was looking for, since I've been away from this for years, and am relearning it all from scratch.

Thanks for your time and attention.

标签： hyperlinkexcel-2010

Answer 1

假设我们想去D列中的“宝藏”：

=HYPERLINK("#d" & MATCH("treasure",D:D,0),"jump to treasure")

如果您不知道要搜索哪一列，这可以修改！