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