ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   hyperlink with vlookup (https://www.excelbanter.com/excel-discussion-misc-queries/46534-hyperlink-vlookup.html)

Mariano922

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

Max

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




Max

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
--




All times are GMT +1. The time now is 01:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com