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 |
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 |