MATCH plus HYPERLINK functions

[F. Lawrence Kulchar]

I am using 2 functions to create a hyperlink in my workbook as follows:
=MATCH(B5&"*",Sheet1!A1:A734,0) is in C5
=HYPERLINK("#A"&C5,"GO TO") is in D5

The problem is: I find the match in line 15 (eg) of Sheet1, but my
hyperlink references the sheet where the formula is enteded (in my case,
sheet1(3)).

How can I fix either my MATCH function or my hyperlink function so that my
hyperlink sends me to the correct spot?

Thanks,

FLKulchar

 

[Dave Peterson]

How about specifying the other worksheet:

=HYPERLINK("#sheet1!A"&C5,"GO TO")

 

[FLKulchar]

Fabulous RSVP...but pls. inform me Why the "#" sign in front of sheet 1!
??

Thanks,

FLKulchar

 

[Dave Peterson]

It's one of those HTML thingies. It means sub-address (as far as I know!).

If you look at web pages, you'll see that this takes you to the page:
http://contextures.com/xlFunctions02.html

But this takes you to a sub-address within that page:
http://contextures.com/xlFunctions02.html#Trouble

 

[FLKulchar]

Thanks!!

FLK

It's one of those HTML thingies. It means sub-address (as far as I
know!).

If you look at web pages, you'll see that this takes you to the page:
http://contextures.com/xlFunctions02.html

But this takes you to a sub-address within that page:
http://contextures.com/xlFunctions02.html#Trouble