Excel vlookup and link to cell question

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

limjizhengshawn

Thread Starter
Joined
Dec 24, 2010
Messages
2
Hello,

I am using Excel 2007
I am trying to create a formula that can search a column in another sheet for a value that matches a cell, and then create a link (on the same cell) that i can click so that it brings me straight there.

So far i have used Vlookup to bring me the information but i cannot seem to create a link to go there.

Any help is much appreciated.
 
Joined
Jul 1, 2005
Messages
8,546
Welcome to the board.

Your info is sketchy so here's a basic example. In the attached is a dynamic named range "Here". The formula defining it is:

=OFFSET(Sheet2!$B$1,Sheet1!$C$6,0)

Where the Sheet1!B9 link takes you depends on the Sheet1!B6 dropdown selection.
 

Attachments

limjizhengshawn

Thread Starter
Joined
Dec 24, 2010
Messages
2
How do i create the hyperlink? I have already defined the named range but i cannot create the hyperlink to click on.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top