JackDanIce
Well-known Member
- Joined
- Feb 3, 2010
- Messages
- 9,922
- Office Version
- 365
- Platform
- Windows
Hi,
I have a cell named File_Filter that contains data validation of a list with 5 values a user can select.
I have a second cell named Quanto, which should always read "No", unless a specific value from File_Filter is selected, in which case, value of Quanto should be "Yes"
Effectively, my ask is:
However, I want to avoid any VBA code based solutions. Can this be done just using Excel and data validation or other Excel built in feature?
Searching online, I can only find articles relating to drop-down lists dependent on values in other cells but it doesn't seem applicable in my case or I need help to implement.
Thanks in advance,
Jack
I have a cell named File_Filter that contains data validation of a list with 5 values a user can select.
I have a second cell named Quanto, which should always read "No", unless a specific value from File_Filter is selected, in which case, value of Quanto should be "Yes"
Effectively, my ask is:
Code:
If File_Filter = "tango" Then
Quanto = "Yes"
Else
Quanto = "No"
End if
Searching online, I can only find articles relating to drop-down lists dependent on values in other cells but it doesn't seem applicable in my case or I need help to implement.
Thanks in advance,
Jack