Multiple If Statements in the same cell
 

I am building a spreadsheet to display all documents I have sent someone. In
cell A1, I have created a drop-down list of households, and now in column B,
I want B1 to display a list of accounts that corresponds to the household in
A1. How do I crate multiple if statements for B1?

For example,

If I select the Smith family in A1, I want to see a drop-down list in B1 of
all smith accounts, but then if I select the Jones family in A1, I want to
only see the Jones Accounts in B1. Thanks!

Multiple If Statements in the same cell
 

http://www.contextures.com/tiptech.html


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JBarsema" wrote in message
...
I am building a spreadsheet to display all documents I have sent someone.
In
cell A1, I have created a drop-down list of households, and now in column
B,
I want B1 to display a list of accounts that corresponds to the household
in
A1. How do I crate multiple if statements for B1?

For example,

If I select the Smith family in A1, I want to see a drop-down list in B1
of
all smith accounts, but then if I select the Jones family in A1, I want to
only see the Jones Accounts in B1. Thanks!

Multiple If Statements in the same cell
 

These are called 'Dependent Lists'. Take a look at this:
http://www.contextures.com/xlDataVal02.html
http://www.contextures.com/xlDataVal13.html


Regards,
Ryan---

--
RyGuy


"Don Guillett" wrote:

http://www.contextures.com/tiptech.html


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JBarsema" wrote in message
...
I am building a spreadsheet to display all documents I have sent someone.
In
cell A1, I have created a drop-down list of households, and now in column
B,
I want B1 to display a list of accounts that corresponds to the household
in
A1. How do I crate multiple if statements for B1?

For example,

If I select the Smith family in A1, I want to see a drop-down list in B1
of
all smith accounts, but then if I select the Jones family in A1, I want to
only see the Jones Accounts in B1. Thanks!