Hi
you may try using VLOOKUP. See:
http://www.contextures.com/xlFunctions02.html

--
Regards
Frank Kabel
Frankfurt, Germany

"John" schrieb im Newsbeitrag
...
I am trying to link from one workbook to another.
The source position changes, for example product 121.1 might be one
cell
lower because a product 120.1 was added.

So how do I paste a link based on a value instead of a cell position?

Thank you for any information

John