Creating a hyperlink based on the cell contents

Topic

New Reply

In Sheet 1, I have a series of cells with text strings. Each text string also appears in Sheet 2. I want to create hyperlinks in Sheet 1 so that clicking on a text string in Sheet 1 jumps to the same string in Sheet 2, regardless of its position in the sheet. Thanks in advance for your help!

Reply | Quote

Replies

This not the complete answer, but it may give you a possible option.
It uses Match to determine the row position of the text string in the other sheet
It uses the Hyperlink function with the address function to build a Dynamic Link
It does assume that the match is the entire cell content.
There are variations of a solution to show how the formula is built up.

Anyway, it’s in the attached file.
If it helps ok, if not (all knowledge is good)

Reply | Quote

Hi Andrew. I tried it out, and I think that will do it — thanks! Dan

Reply | Quote