MATCH -- HYPERLINK functions

  • Thread starter F. Lawrence Kulchar
  • Start date

F

F. Lawrence Kulchar

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
 
Ad

Advertisements

F

FLKulchar

This reply is from the author....I have discovered the problem:

The "sheet reference" canNOT have any blanks in it!

Thanks,

FLKulchar
 
G

Gary''s Student

Also avoid #
--
Gary''s Student - gsnu200789


FLKulchar said:
This reply is from the author....I have discovered the problem:

The "sheet reference" canNOT have any blanks in it!

Thanks,

FLKulchar
 
Ad

Advertisements

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

Top