In the file attached I am trying to pull out open and filled positions for HR into department worksheets.

Everything seems to be working except for the Member Operations tab, which is pulling in one of the jobs just fine but the others that are deemed to be in MemberOperations dont seem to want to populate.

The "Category lookups" tab establishes the crosswalks for which category is in which department.

Thanks in advance!

Department Position Status working file.xlsx