The spaces are the problem. Use:
Alph._by_State
for the new sheetname.
--
Gary''s Student - gsnu200789


"F. Lawrence Kulchar" wrote:

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