Multiple Criteria Array Formula Help

[RicardoCubed]

Hi out there. I have the below array formula in cell C43 (which with prior help from this great forum) works great. I now want to add a second criteria to this - in my case the "supervisors name" in cell D41. I tried a few things in cell C43 like if & and as well as couple other combos. Its not coming to me.
Help appreciated. Summary is want to be able to put in cost center and supervisor and formula returns all of the people (names) that fit in C43 and down!
Thanks in advance!!!!

Excel 2010
	B	C	D	E
40		Cost Center (Insert ------->)	32 os	3.00
41		Supervisor Name (insert -->
42	Count	Name (Concatenated)	FTE	Salary
43	1	Andy, Amos N	-	1.00
44	2	Boop, Betty	-	1.00
45	3	Chaplin, Charlie	-	1.00
46	#N/A	-	#N/A	#N/A
Load

Cell Formulas
Range	Formula
E40	=E115
E43	=INDEX(Detail!$X$3:$X$590,MATCH($C43,Detail!$CT$3:$CT$590,0))
B43	=IF(D43<>"na",ROW()-ROW($B$43:B43)+1,"-")
D43	=INDEX(Detail!$N$3:$N$590,MATCH($C43,Detail!$CT$3:$CT$590,0))
C43	{=IFERROR(INDEX(Detail!CT$3:CT$530,SMALL(IF(Detail!$J$3:$J$530=$D$40,ROW(Detail!CT$3:CT$530)-ROW(Detail!B$3)+1),ROWS(Detail!B$3:Detail!B3))),"-")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[C Moore]

I think you should be able to multiply your criteria. ...If((Detail!$J$3:$J$530=$D$40)*(SupervisorNameRange=$D$41),ROW(...

 

[RicardoCubed]

That did the trick!!!!! Thanks!!!!