I've attached a copy of your template with a change on the rule on the dropdown - I'm guessing you want the rule to run when the field is not blank (though you may want to add rules to clear fields when the office changes), but you were missing a filter on your data when you select from the secondary data. Your secondary data will have 0 to many rows, and you need to use the filter data button when you pick a field to indicate which row has the data you need. :)
Hilary Stoupa
