Clearing associated dropdown fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
To control the entries in column A, without programming, you could type NA
in a cell, and name that cell NAList.
Then, in the first column with data validation, Allow: List, and for the
formula enter:

=IF(B2="",Produce,NAList)

If there's an entry in column B, you will only be able to choose N/A in
column A.
 
Debra,

Thank you for the tip. Works great. If I wanted to do it via programming,
is it possible?

TC
 
Back
Top