If anyone is interested, here's how I set it up:
Using Expression Builder:
Make sure to set the "Department Name" and "Division Name" as follows:
IIF([department]="Department name", "Division Name",
IIF([department]="Department name", "Division Name",
IIF([department]="Department name", "Division Name",
IIF([department]="Department name", "Division Name",
IIF([department]="Department name", "Division Name",
IIF([department]="Department name", "Division Name",
IIF([department]="Department name", "Division Name",
IIF([department]="Department name", "Division Name",
IIF([department]="Department name", "Division Name",
IIF([department]="Department name", "Division Name",
IIF([department]="Department name", "Division Name",
IIF([department]="Department name", "Division Name",
IIF([department]="Department name", "Division Name",
IIF([department]="Department name", "Division Name",
IIF([department]="Department name", "Division Name",
IIF([department]="Department name", "Division Name",
IIF([department]="Department name", "Division Name",
"Home")))))))))))))))
------------------------------
Pat Johnson
Sr. Solutions Analyst
------------------------------