Hello,

I have a spreadsheet with a dropdown list. When a particular item is
selected from the dropdown list, a second field is populated. For instance,
the dropdown menu is in cell A1, if a selection is made then B2 is populated.
My issue is the following: If an item is selected from A1, B2 will be
populated, but if the person changes the item in A1, the previous value
remains in B2. Is it possible to "clear the field once A1 has changed values?
Can I do this w/o VB? Any help would be much appreciated.

thanks,

TC