MATCH plus HYPERLINK functions

  • Thread starter F. Lawrence Kulchar
  • Start date

F

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
 
Ad

Advertisements

F

FLKulchar

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

Thanks,

FLKulchar
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top