Hyperlink - External FIle

[doylzer]

Hey All,

Hope you guys can help.

I have attached an excel to help explain my issue.

On the attached, If i change cell F2 to match any value in column A then i would like to return the text in column C in G2 (i assume like a vlookup) but want to create a Link instead where I can click on it and it will bring me to the cell in Column B.

In my example i want Cell G2 to have a link that would bring me to Cell B2. However in the exmaple if i entered 1.03 then G2 remains empty.

hope this is all clear.

Additionally, how could i change this to look up a external excel file saved on my computer?

Stephen

[PaulM100]

The formula below can be used in the same workbook.
=HYPERLINK("#"&CELL("address",INDEX(B:B,MATCH(F2,A:A,0))),INDEX(B:B,MATCH(F2,A:A,0)))

[doylzer]

Thanks so much. Massively helps me.
Can i ask what part i could change of the formula i would need ot change if the source of data was in a separate excel?

[PaulM100]

n the same sheet
=HYPERLINK("#A1"&CELL("address",INDEX(B:B,MATCH(F2,A:A,0))),INDEX(B:B,MATCH(F2,A:A,0)))
in the same workbook
=HYPERLINK("#Sheet5!A1"&CELL("address",INDEX(B:B,MATCH(F2,A:A,0))),INDEX(B:B,MATCH(F2,A:A,0)))
to another workbook (must be open!)
=HYPERLINK("#'[series .xlsm]Excel'!$A$1"&CELL("address",INDEX(B:B,MATCH(F2,A:A,0))),INDEX(B:B,MATCH(F2,A:A,0)))