Forum Discussion
linked cells don't update correctly to other notebooks
Hello, Let me explain.....I have a Master cost sheet that has its cells linked to 6 other notebooks. The links work fine i.e. if I update a cost in the Master, the other related notebooks correctly...
It'd be better to assign a unique ID to each item and to use VLOOKUP or XLOOKUP formulas to retrieve the data for an ID.
Hans,
Thanks for the quick reply.
I am vaguely familiar with VLOOKUP.... I'll investigate.
Thank you
Thanks for the quick reply.
I am vaguely familiar with VLOOKUP.... I'll investigate.
Thank you