Prev: Addition to a working formula
Next: How to check if the values in a range of cells are greater than 0
From: rittzy on 19 Mar 2010 01:47
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.
From: Jacob Skaria on 19 Mar 2010 02:01
Select B3. From menu Data>Validation>Allow 'List' and in Source field enter
the below formula..

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

--
Jacob


"rittzy" wrote:

> 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.
 | 
Pages: 1
Prev: Addition to a working formula
Next: How to check if the values in a range of cells are greater than 0