Hi all,
I have a sheet with a number of hyperlinks in some cells. Some cells are linked and some aren't.
I wanted to do formula in another sheet that would bring up the hyperlink. I have tried the following but it doesn't work.
Any help?
[=HYPERLINK(INDEX(Masterfile!A$7:A$8000,MATCH('Tomb&CaseStudy'!$K7,Masterfile!$FM$7:$FM$7999,0)))]
Thanks,
Daniel
It worked just fine for me in testing.
Well, it had to have the explicit full address in the INDEX range; my guess would be there's something not quite right with the address in Masterfile!A7:A8000 that you're looking up.
What exactly do you mean by "doesn't work"? Is it throwing an error like #N/A (probably because the lookup isn't finding a match) or is the hyperlink getting rejected as invalid or what?
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks