I have 2 columns one is list and other is data validation with dropdown from that list,
one two three
reference (the table where I use that list)
three one one
The formula for the list is
When I change value of item in the list, the list reference cell that uses that data does not update.
Say I change
four in list row 3, the reference will still show