Encountering Runtime Error 1004 "That name is already taken. Try a Different One.

Hi There,
I a new to VBA coding. I have encountered runtime error 1004 "That name is already taken. Try a different one.", when i have used the dynamic hyperlink formula from one sheet to another.

Suppose i got the text on sheet1 Cell: B10 i want to match the text in sheet2 Cell: B6, where in sheet2 there are lookup formulas used to a different sheets. Now when text in sheet1 matched with text in sheet2 i clicked on link it gives me runtime error 1004. Could you please help me resolve this problem ?

Formula i used:

HTML Code: 

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread