MATCH plus HYPERLINK functions
 

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

MATCH plus HYPERLINK functions
 

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

MATCH plus HYPERLINK functions
 

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

MATCH plus HYPERLINK functions
 

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

MATCH plus HYPERLINK functions
 

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