Hi,
I'm trying to link a cell in one row to a cell in another row so that the linked-to cell automatically updates when the original cell is changed. Everything I've tried (relative and absolute cell references; link cells; Paste as link, etc.) works fine.....UNTIL I sort the file and the row numbers change. To try to figure this out I created a simplified version of my actual file (see attached). Also, in the first screen capture below, Column B is the Item Name; Column C is a number associated with that item; Column D (highlighted) is the value I'm trying to achieve by linking to the specific cell in Column B. In Columns E-J, I've tried different formulas, and they all give the correct value before sorting:
Excel-question-1.png
However, as soon as I sort by Column A, then all the values skew from the desired value in Column D:
Excel-question-2.png
I've wracked my brain trying to figure this out. Thanks for any help somebody might have!
Stan
Bookmarks