I have a list of products to be made. On the next column I have a Lookup
function that brings up descriptions and info based on that list. I usually
need that base list to be reorganized. Unfortunately, I can't just drag
them into the order I need b/c the lookup function tracks where the cell
went and now the descriptions do not match next to their product. Is there
a way to disable this, or is copy.paste.erase old. the only way to go?

Chris Cameron