Unsure how to set up Data validation, dependent on value from list

JackDanIce

Well-known Member
Joined
Feb 3, 2010
Messages
9,922
Office Version
  1. 365
Platform
  1. 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:
Code:
If File_Filter = "tango" Then
  Quanto = "Yes"
Else
  Quanto = "No"
End if
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
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Forgot to mention, I wish to avoid using a formula in cell Quanto as well.
 
Upvote 0
dunno i cant understand your problem; can you formulate it on a sheet with the expected behavior and paste here using Mr.Excel HTML maker?

what i understood looks quiet simple and straight forward to do:


Excel 2010
BCDEFGH
2File_nameQuantoz
31alphaalphano
42bravo
53gamma
64monkey
75echo
8
9
10
Sheet1
Cell Formulas
RangeFormula
F3=IF(E3=C6,"yes","no")
 
Upvote 0
I wanted to avoid using a formula in the Quanto cell (thread #2), but have since reverted to together with cell protection and locked worksheet.

Problem resolved and thread closed.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,514
Messages
6,114,078
Members
448,547
Latest member
arndtea

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top