In cell D4, I have:

=MATCH(C4&"*",'Alph. by State'!A1:A1083,0)

I wish to create a hyperlink to sheet entitled "Alph. by State"...I changed
the name of Sheet1 to "Alph. by State".

In cell E4, I have:

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

The hyperlink worked fine until I renamed sheet1 to "Alph. by State".

I cannot seem to fix my cell E4..I get error message,
"reference not valid".

PLEASE HELP.

Thanks,

FLKulchar