Auto Fill in for List - based on another cell's value

[Closed]
Report
Posts
1
Registration date
Monday August 15, 2016
Status
Member
Last seen
August 15, 2016
-
Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
-
Hi!

I have different sections of an excel document that feature the same lists over and over again. Sometimes the values selected will be different for each section and sometimes they will all need to be the same.

Essentially, I want to give an override button where if turned on, the selection in this first list will filter down to the lists below OTHERWISE, if the override is not selected, the list will show.

I have the override section and list completed. I just cannot figure out how to create an IF statement that points to a cell value OR a list.


I am not sure how to include an excel sheet in this but pretend the dollar amounts are lists that show multiple values to select

Master Override

Yes
Limits
$100,000/$100,000

Part A
$250,000/$250,000

Part B
$100,000/$100,000

Part C
$100,000/$100,000

Part D
$100,000/$100,000



If Master Override = 'Yes', Part A, B, C, D = Limits



Is there a way to do this?

Thanks!

1 reply

Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
1
Not really sure what you want here. What would a sample answer look like for YES, and what would it look like for NO?