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

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