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

Validation list based on criteria 0
If OR formula 1
Data Validation and drop-down list using IF, AND and what else? 8
Formatted cell column in drop down list 1
How to dynamically change the list in drop down list based on thevalue of another cell? 1
If function help 4
a data validation list that contains a list of named ranges - not alist from a named range 1
Return a value if a range of cells contain text 2

Top