Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink w/ vlookup
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hyperlink w/ vlookup
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",I NDIRECT("'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 --- "tsedlock" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using vlookup and hyperlink | Excel Worksheet Functions | |||
HYPERLINK and VLOOKUP help | Excel Discussion (Misc queries) | |||
HYPERLINK AND VLOOKUP help | Excel Worksheet Functions | |||
HYPERLINK AND VLOOKUP help | Excel Discussion (Misc queries) | |||
hyperlink with vlookup | Excel Discussion (Misc queries) |