Hyperlink w/ vlookup


T

tsedlock

I have a list of companies with their addresses on a separate tab. I want to
set up a hyperlink so that, when I click on the company name, I am linked to
the cell on tab2 that displays their contact info. I'm thinking combination
of vlookup and hyperlink, but I'm not sure. How do I do this, or is there a
better way that I'm not considering?
 
Ad

Advertisements

M

Max

One way for the "match-n-jump-to" functionality sought
is illustrated in this working sample from my archives:
http://savefile.com/files/2152556
Hyperlink_matching_record_in_another_sht.xls

The complete formula, inclusive error-trapping, looks like this:
=IF(A2="","",IF(ISNA(MATCH(A2,'By
Product'!B:B,0)),"",HYPERLINK("#"&CELL("address",INDIRECT("'By
Product'!B"&MATCH(A2,'By Product'!B:B,0))),A2)))

Aloha? Click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top