Believe the underlying intents here could be served via using either VLOOKUP
or INDEX/MATCH

Look through Debra's nice coverage on VLOOKUP or INDEX/MATCH at her:

http://www.contextures.com/xlFunctions02.html
VLOOKUP

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Harlan" wrote:
I've created a set of workbooks, one that is a master inventory list, and the
rest that are recipe costing sheets (this is for a restaurant). What I want
to do is link the inventory products to the recipes back to the corresponding
production item on the inventory list. The problem that I keep having is
that if a add an item to the inventory list (row), the value in the recipe
changes because the link follows the cell not the value. Is there a way to
prevent this? Can I have these links locked in to specific values, no matter
if 2 or 10 rows are added.
Thanks