Indexing Help

Amber N

I need some help getting this to pull the right data. I have two sheets:

PACE Appeals and Grievance Reference that I want to link.

In PACE Appeals I want the 'Dept Contact' cell to bring back an index match based off of 'Dept Responsible For Follow-Up' & 'Center' (The first column is label Center it just isn't showing up for some reason):

From this sheet:

Any suggestions are very welcome!

Paul Newcome

You would use something along the lines of

=INDEX(COLLECT({Contact Column}, {Dept Column}, @cell = [Department Column Name]@row, {Center Column}, @cell =[Center Column Name]@row), 1)