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

How about specifying the other worksheet:

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



F. Lawrence Kulchar wrote:

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

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

Thanks,

FLKulchar
"Dave Peterson" wrote in message
...
How about specifying the other worksheet:

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



F. Lawrence Kulchar wrote:

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

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 wrote:

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

Thanks,

FLKulchar
"Dave Peterson" wrote in message
...
How about specifying the other worksheet:

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



F. Lawrence Kulchar wrote:

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

--

Dave Peterson

Thanks!!

FLK
"Dave Peterson" wrote in message
...
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 wrote:

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

Thanks,

FLKulchar
"Dave Peterson" wrote in message
...
How about specifying the other worksheet:

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



F. Lawrence Kulchar wrote:

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

--

Dave Peterson