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 are not matching anymore the original name.

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

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, 2022 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, 2022 at 18:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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