Hyperlink hell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,

I need a way to make a hyperlink to a cell in another worksheet where i
don't know the cell reference. I'll explain it more clearly...

At the moment i have =VLOOKUP(C6,Brother!A18:C25,2) which returns a text
string. After this i want to be able to click on the cell (where the text
string is displayed) and for it to 'jump' to the cell where it got this
information.

So far i can find heaps of functions that will search for the information in
a cell but i can't find one that will give me an output of the cell
reference. I'm sure there must be one that i have over looked.

Thanks
 
Hi
try
=HYPERLINK("'C:\temp\book.xls#Brother'!B" &
MATCH(C6,Brother!A18:A25),VLOOKUP(C6,Brother!A18:C25,2))


Though if you search for an exact match you may change this to:
=HYPERLINK("'C:\temp\book.xls#Brother'!B" &
MATCH(C6,Brother!A18:A25,0),VLOOKUP(C6,Brother!A18:C25,2,0))
 
Can not find specified file.

I tryed a few different links but it still wasn't happy. Just so you know I
only need to link within the same file just different worksheets. Don't know
if that helps tho.
 
Hi
try:
=HYPERLINK("#'Brother'!B" &
MATCH(C6,Brother!A18:A25),VLOOKUP(C6,Brother!A18:C25,2))

Note: the characters # and ' at the beginning are important
 
Back
Top