Hyperlink to a cell that have specific text

[Unexpc]

Hi guys
Anyway create hyperlink that linked to a specific text? (The range of sheet is changable and this text may A10 and after entered data will be A11 and ...)

 

[Oaktree]

Sure, try something like:

=HYPERLINK("#'Sheet1'!A"&MATCH("String to Find",A:A,0),"What to display")

 

[Unexpc]

Sure, try something like:

=HYPERLINK("#'Sheet1'!A"&MATCH("String to Find",A:A,0),"What to display")

I try but not work, i insert this =HYPERLINK("#'Sheet1'!A"&MATCH("CustomerA",A:A,0),"CustomerA")
what am i wrong?

 

[Oaktree]

Probably the sheet name.

Try this more generic approach: =HYPERLINK("#'This Sheet Name'!A"&MATCH("CustomerA",'This Sheet Name'!A:A,0),"CustomerA")

where This Sheet Name is the name of the tab where you're searching for Customer A.

 

[Unexpc]

Probably the sheet name.

Try this more generic approach: =HYPERLINK("#'This Sheet Name'!A"&MATCH("CustomerA",'This Sheet Name'!A:A,0),"CustomerA")

where This Sheet Name is the name of the tab where you're searching for Customer A.

You Are Right, Thank You