| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MATCH -- HYPERLINK functions
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MATCH -- HYPERLINK functions
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MATCH -- HYPERLINK functions
This reply is from the author....I have discovered the problem:
The "sheet reference" canNOT have any blanks in it! Thanks, FLKulchar "F. Lawrence Kulchar" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MATCH -- HYPERLINK functions
Also avoid #
-- Gary''s Student - gsnu200789 "FLKulchar" wrote: This reply is from the author....I have discovered the problem: The "sheet reference" canNOT have any blanks in it! Thanks, FLKulchar "F. Lawrence Kulchar" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MATCH -- HYPERLINK functions
The "#" is required:
It's one of those HTML thingies. It means sub-address (as far as I know!). If you look at web pages, you'll see that this takes you to the page: http://contextures.com/xlFunctions02.html But this takes you to a sub-address within that page: http://contextures.com/xlFunctions02.html#Trouble FLKulchar "Gary''s Student" wrote in message ... Also avoid # -- Gary''s Student - gsnu200789 "FLKulchar" wrote: This reply is from the author....I have discovered the problem: The "sheet reference" canNOT have any blanks in it! Thanks, FLKulchar "F. Lawrence Kulchar" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MATCH -- HYPERLINK functions
I agree. I meant the tabname.
-- Gary''s Student - gsnu200789 "FLKulchar" wrote: The "#" is required: It's one of those HTML thingies. It means sub-address (as far as I know!). If you look at web pages, you'll see that this takes you to the page: http://contextures.com/xlFunctions02.html But this takes you to a sub-address within that page: http://contextures.com/xlFunctions02.html#Trouble FLKulchar "Gary''s Student" wrote in message ... Also avoid # -- Gary''s Student - gsnu200789 "FLKulchar" wrote: This reply is from the author....I have discovered the problem: The "sheet reference" canNOT have any blanks in it! Thanks, FLKulchar "F. Lawrence Kulchar" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HYPERLINK, MATCH functions | Excel Discussion (Misc queries) | |||
| MATCH plus HYPERLINK functions | Excel Discussion (Misc queries) | |||
| MATCH plus HYPERLINK functions | Excel Discussion (Misc queries) | |||
| hyperlink functions | Excel Worksheet Functions | |||
| When MATCH and v/hLOOKUP functions *FAIL* to match (but they should)... | Excel Worksheet Functions | |||
Linear Mode
