data_Example.xlsx

I'm trying to form a drop-down list by looking up the value of a cell and searching for it in a table/range and then build the list with the 2nd column that corresponds to each matching row. I feel like I was close with some info I found here: http://fiveminutelessons.com/learn-m...le-values-list but this formula requires you to copy for each instance of each row. I need the formula to built the array for each of the rows automatically. Thanks for any help that you can provide!

Dept # Fund
123 checking
123 savings
123 bonds
321 cash
321 coins

Chosen Dept: 123
Select Fund: I would like B9 to be a Data Validation List that would include {checking, savings, and bonds} as the only options