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!