I am taking a range of names from another tab with the formula =SORT(UNIQUE('brands check'!B9:B8228)) in column B. I would like to add descriptions in other columns (D,E, etc) but as soon as I add a new name in the 'brands check' file the list is changing, and the descriptions or not matching anymore the original name.

Is there a way to keep the description attached to the shifting name?

Thank you

1 Answer 1


You'll need to insert the other columns like this (note the curly brackets):

'brands check'!B9:B,
'brands check'!C9:C,
'brands check'!D9:D
  • Thank you for the answer. The columns where I want to add the description are entered manually and not from the other tab (brands check).
    – Mattia
    Aug 19 at 17:27
  • The description of an element must be made in the same table as the element, any other position would be conceptually wrong.
    – Daniele
    Aug 19 at 18:46
  • Thank you for the answer.
    – Mattia
    Aug 22 at 12:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.