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?