Multiple If Statements in the same cell

[JBarsema]

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!

 

[Don Guillett]

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

 

[ryguy7272]

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


Regards,
Ryan---