Adding rows without the links moving

[Guest]

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

 

[Guest]

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

 

[Guest]

This seems to be a lot of work for what I want, but I'm willing to give it a
try. Also because of the way the inventory sheet is broken down, I don't
know if it will work. Any other suggestions.

Thanks

 

[Max]

Thanks for feedback. I'm out here. Hang around awhile for possible responses
from others. Good luck !