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)