Using VLookup to give Hyperlink to a cell in another worksheet

[AlpAnA$]

Please some help me to succeed. I have done many researches on internet but did not succeed. My issue is that I am trying to link the cell from one worksheet to another worksheet based on matching values with the help of Hyperlink function. I have done this hyperlink manually up till know but I want a dynamic formula or alternative using VLookup. Please provide necessary help.

[Steyn]

You can use the below formulas to give Hyperlink to a cell in another worksheet using VLookup.

• In Sheet1- A2:
  
  =HYPERLINK("#INDEX(sheet2!A:A,MATCH(100,Sheet2!A:A,0))",100)
  
• For adjacent columns Sheet1- C2:
  
  =HYPERLINK("#INDEX(Sheet2!A:A,MATCH("&A2&",Sheet2!A:A,0))","View "&A2)

[Vandam]

If you are still unable to use VLookup to give Hyperlink to a cell in another worksheet then try the following:

This is the easiest formula you can use:

=IF(A1="","",HYPERLINK("["&MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, 
SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)&"]
'Sheet2'!A"&MATCH(A1,Sheet2!$A$1:$A$295,0),"Link"))

If the range you were searching in on Sheet2 started at 
A2 then you would have to add 1 (I've underlined it below)

=IF(A1="","",HYPERLINK("["&MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, 
SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)&"]
'Sheet2'!A"&MATCH(A1,Sheet2!$A$1:$A$295,0)+1,"Link"))

[Jacques25]

• If you want to change the cell then you have to change values in two cells.

=IF(A1="","",HYPERLINK("["&MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)&"]'Sheet2'!A"&MATCH(A1,Sheet2!$A$1:$A$295,0),"Link"))

• If you want to change the column that it points to you need to change the 2 values underlined below:

=IF(A1="","",HYPERLINK("["&MID(CELL("filename"),SEARCH("[",CELL("filename"))+1, SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)&"]'Sheet2'!A"&MATCH(A1,Sheet2!$A$1:$A$295,0),"Link"))

[Dwarner]

Just adjust the B range as I have done below:

1. Sheet1-A2:
   =HYPERLINK("#INDEX(sheet2!B:B,MATCH(100,Sheet2!A:A,0))",100)
   
2. Sheet2-B2:
   =HYPERLINK("#INDEX(Sheet1!A:A,MATCH("&A2&",Sheet1!A:A,0))",50)