Home |
Search |
Today's Posts |
#1
|
|||
|
|||
hyperlink with vlookup
=HYPERLINK[=vlookup(a2;CARATULAS!$A$4:$D$146;4;0)]
I´ve got to create an hyperlink that (according to a value in the same row) takes me to the same value in another worksheet. Please help me!- Thanks |
#2
|
|||
|
|||
One play which could do this ..
Link to a sample file at: http://www.savefile.com/files/6398176 File: AutoHyperlink_Mariano922_wksht.xls Assume you have this set-up In Sheet1, cols A & B, data from row2 down ------------ Prod# UnitPrice 1111 10 1112 20 1113 30 1114 40 1115 50 etc In CARATULAS -------- Prod# are listed in col A & BulkPrice in col D (col D is the lookup col), with data from row4 down Prod# BulkPrice 1114 1 1115 2 1113 3 1111 4 1112 5 etc Product #s above are intentionally scrambled to be different from the order in Sheet1. This is for illustration purposes when we check that clicking on the hyperlinks created does jump to the correct cells in Sheet2. In Sheet1 --------- Put a label in C1, say: BulkPrice hyperlink Put in C2: =HYPERLINK("#"&CELL("address", INDIRECT("'CARATULAS'!D"&MATCH(A2,CARATULAS!A:A,0) )),A2) Copy C2 down This will create hyperlinks in C2, C3, etc using the product #s in col A as the friendly names. And when you click on the hyperlinks, they'll bring you to the correct lookup cell in col D in CARATULAS Adapt to suit .. (change also the commas to semicolons to suit your Excel's language) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Mariano922" wrote in message ... =HYPERLINK[=vlookup(a2;CARATULAS!$A$4:$D$146;4;0)] I´ve got to create an hyperlink that (according to a value in the same row) takes me to the same value in another worksheet. Please help me!- Thanks |
#3
|
|||
|
|||
Think
BulkPrice in col D (col D is the lookup col), reads better as: BulkPrice in col D (col D is the return col), The value in col D is where you want the hyperlink to jump to -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup hyperlink | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
DropDown with VLOOKUP & HYPERLINK | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
carrying a hyper link when using the vlookup function | Excel Worksheet Functions |