creating a link to a specific character string

Why does the cell address change? Is it due to insertions and deletions, or does it just move around to random places?

It sounds like this requires a macro. If you provide more detail and attach a file we can suggest a solution. The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

Hypothetically yes, can you post a sample file?

Off the top of my head, and presuming the sting you want to link to is in a single cell and unique to that sheet, I would create a lookup to get the cell the string is in and pass it to the INDIRECT function which turns the string to a reference. That should effectively be equivlent to doing something like "=A1" but A1 would be dynamically formed using a lookup on your string.

Need a bit more detail. Is the value unique in the sheet (link destination)? And is it going to be in specific row/column?

If yes to both. It can be done using following construct

Formula:

Please Login or Register  to view this content.

"#" is needed to hyperlink with cell in a same workbook.

If you need 2d lookup, you'll need additional criteria to find the column index# and use R1C1 style formula using indirect.

If you need further help, please upload sample workbook.