google sheets - Is there a way to create an editable list in a separate tab for automated content?

Question

I have a CSV that is pulling in content automatically and am wondering if there is a way to assign values to the 'Title' and 'Colour' variants in a list in the second tab, rather than editing the formula each time I would like to add a new Title or Colour.

The 'Title' and 'Colour' variants are determined by values assigned in column N. I would like, if possible, to create new Colours and Titles and assign them values in a list in the second tab.

I have created an example CSV with the necessary columns highlighted.

Column B - Product title Column I - Colour

Link to CSV

https://docs.google.com/spreadsheets/d/1c8TyIL_GGtyIEWV6igNzM705cSt4nSTIpGuUl_UTN1w/edit?usp=sharing

question from:https://stackoverflow.com/questions/65830074/is-there-a-way-to-create-an-editable-list-in-a-separate-tab-for-automated-conten

Answer 1

Try this:

B1: =arrayformula(IF(A1:A="Handle","Title",VLOOKUP(INDEX(SPLIT(N1:N, "-"),,1),Title,2,false)))

I1: =arrayformula(IF(A1:A="Handle","Colour",VLOOKUP(INDEX(SPLIT(N1:N, "-"),,2),Colour,2,false)))

I added "false".