Forum Discussion
Hyperlink copy/paste
The formula in Sheet!C2, copied down rows, is:
=HYPERLINK("#Sheet2!B"&
MATCH(LEFT(D2),Sheet2!B:B,0),
LEFT(D2))
Please see the attached file and inform me if the foregoing formula returns your desired result.
Thank you so much for your reply and help!
When I copied your formula from the dummy sheet to the actual, I realized a minor issue. Column D are names or people (see excel sheet for example) and column C are names of companies. This is the issue because when I used your formula on the actual sheet, it returned with: #NAME?
Hopefully I'm making sense. Let me know if I need to explain further.
For the hyperlink to work, Column D of Sheet 1 must match with Column B of Sheet 2. Thus, the formula in Sheet1!C2, copied down rows, is:
=HYPERLINK("#Sheet2!B"&MATCH(D2,Sheet2!B:B,0),
D2)Thank you again for your help with this.
For sheet 1, columns C and D are different names. Column C is a company name whereas column D is a name of a person responsible for the engagement with that company.
On sheet 2, column B is the same company name as sheet1 column C.
I think this changes things in the hyperlink formula.
