IF statement based on True/False that activates a certain list box

R

rittzy

I've been asked to create a formula that will react to either "yes" or "no"
entered into a cell which will show options in another cell based on a
certain list.

Example:
Cells D3:D5 contain the values Monday, Tuesday, Wednesday (list named BegWeek)
Cells E3:E5 contain the values Thursday, Friday, Saturday (list named EndWeek)
Cell A3 accepts either "yes" or "no" entry only from a list
If A3 = "Yes" then B3 will = drop down list BegWeek
If A3 = "No" then B3 will = drop down list End Week

I don't even know if this can be done in Excel but I am being asked to try.
Considering a combination of formulas/macros but have no idea how to pull it
off. Any ideas are greatly appreciated.
 
J

Jacob Skaria

Select B3. From menu Data>Validation>Allow 'List' and in Source field enter
the below formula..

=IF(A3="Yes",begweek,IF(A3="No",endweek))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

a data validation list that contains a list of named ranges - not alist from a named range 1
Moving data based on date ranges 1
IF statement with lists and dropdowns 1
How do I create "IF" function with a drop down list? 10
Array Substitution Based on Drop Down List 1
vlookup() error #n/a 3
Data Validation List from a Dynamic Named Range on Another Workshe 5
Filter the results of a list based on a previous vlookup against the same list 3

Top