Creating hyperlinks across a single sheet?

**JBeaucaire** · 05-16-2013, 07:34 PM

I do this all the time, but without VBA. The HYPERLINK() formula can be utilized in a adjacent cell to spot a value in another range and provide a clickable link that random spot.

3D HYPERLINK

**CdrJameson** · 05-17-2013, 04:22 AM

Thanks for the advice; I'll try it out when I get back to work on Monday.

**CdrJameson** · 05-21-2013, 12:40 PM

Well I couldn't try on Monday but I got the chance to try today, Tuesday.

Unfortunately I wasn’t able to get the formulas working to my needs. I have attached a basic spreadsheet that demonstrates roughly what I am trying to accomplish.

query_zps7f846828.png

I have manually added the hyperlinks in F3 and C10 to refer back to the parent reference, a simple task but multiplied by 500 times…

In F4 I have added the formula for a +HYPERLINK(ADDRESS(MATCH())) that is almost working. When I read up about the MATCH() function It says that it will only return the relative position of the search term. In my example the hyperlink in F4 links to A4, I understand why it addresses A4 but if I get the MATCH function to return the address of the found cell, is it possible to adapt the formula so that it returns the cell reference and hence hyperlink to B13?

Having looked at the ‘3D Hyperlink’ hyperlink I think that is maybe what I am after (I have cut and paste the example into my spreadsheet at F5), but when I try to work out what the function is doing and adapt it to my spreadsheet my head fails.

Can anyone explain and solve my issue?

I am using excel 2003 at work - if that helps anybody's answer.