I have used Data Validation to display a list of variables. I also have a secondary list whose content is based on the value selected in the first list. When I select a different value in List 1, List 2 is updated correctly, however, the cell displaying List 2 continues to display the old value. Is there a way to get the cell displaying the value from list 2 to either update or go blank when list 1 selection is changed?
Thanks