Quote Originally Posted by JeteMc View Post
I put the following in K8 of the 'Goal' sheet, dragged the fill handle over to AH8 then down to AH30. I got the same values as were previously manually placed in that range, so I used the same formula on the 'Dept_0' and 'Dept_1' sheets and got results that seemed reasonable.
Formula: copy to clipboard 
=IFERROR(INDEX(Master!H$4:H$500,AGGREGATE(15,6,(ROW($4:$500)-3)/((Master!$A$4:$A$500=$B8)*(Master!$D$4:$D$500=$G8)),1)),"")

Let us know if you have any questions.
You're awesome! I plugged it in and it seems to work perfectly!