Hi, hoping for some help.
I have two Data Validation lists. The first contains:
None
Web
Inhouse
the second contains:
Yes
No
Is it possible for the second to auto populate to 'No' if they select 'None' from the first list? Thanks
Hi, hoping for some help.
I have two Data Validation lists. The first contains:
None
Web
Inhouse
the second contains:
Yes
No
Is it possible for the second to auto populate to 'No' if they select 'None' from the first list? Thanks
Have a look at this link, this should sort you out
mhtml:http://officeimg.vo.msecnd.net/en-gb...F010285763.mht
Excel Guru in the making
<----------If the question has been answered to your satisfication please click the Add Repuation star to the left
Thanks TheCman81. Yes I had seen this and it doesn't quite work. If the value is already set to Yes and then you change the first list value to None. The second list value will stay at Yes until you manually change it (the only option available to you then is No). I'm looking to auto populate the second list value.
Is the second selection only ever going to be Yes or No?
If so you can use a formula
=IF(A1="None","No","Yes")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks