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