Return a Result Based on 2 Criteria

Hello everyone

Please see attached. I am trying to write a formula that will fill up column K and L based on the Dept # and Acct.

For example, for K2: return the Line if the Dept # in column I matches that in column C and if the Acct falls within the range indicated by the From (col D) and To (col E) columns.

The desired results are in the Desired Result tab.

I would really appreciate any help on this.

Hi,

try this:
Excel 2013 32 bit

	A	B	C	D	E	F	G	H	I	J	K	L
1	Line	Description	Dept #	From	To				Dept #	Acct	Line	Description
2	900	Mfg Costs 1	00	4010	4070				00	4010	=INDEX($A$2:$A$11,MATCH(1,(I2=$C$2:$C$11)*((J2>=$D$2:$D$11)*(J2<=$E$2:$E$11)),0))	=INDEX($B$2:$B$11,MATCH(1,(I2=$C$2:$C$11)*((J2>=$D$2:$D$11)*(J2<=$E$2:$E$11)),0))
3	900	Mfg Costs 1	00	4200	4300				00	4205	=INDEX($A$2:$A$11,MATCH(1,(I3=$C$2:$C$11)*((J3>=$D$2:$D$11)*(J3<=$E$2:$E$11)),0))	=INDEX($B$2:$B$11,MATCH(1,(I3=$C$2:$C$11)*((J3>=$D$2:$D$11)*(J3<=$E$2:$E$11)),0))
4	1000	Freight	01	4310	4311				03	4350	=INDEX($A$2:$A$11,MATCH(1,(I4=$C$2:$C$11)*((J4>=$D$2:$D$11)*(J4<=$E$2:$E$11)),0))	=INDEX($B$2:$B$11,MATCH(1,(I4=$C$2:$C$11)*((J4>=$D$2:$D$11)*(J4<=$E$2:$E$11)),0))
5	1100	Mfg Costs 2	02	4320	4340				05	4702	=INDEX($A$2:$A$11,MATCH(1,(I5=$C$2:$C$11)*((J5>=$D$2:$D$11)*(J5<=$E$2:$E$11)),0))	=INDEX($B$2:$B$11,MATCH(1,(I5=$C$2:$C$11)*((J5>=$D$2:$D$11)*(J5<=$E$2:$E$11)),0))
6	1100	Mfg Costs 2	03	4345	4350				04	4700	=INDEX($A$2:$A$11,MATCH(1,(I6=$C$2:$C$11)*((J6>=$D$2:$D$11)*(J6<=$E$2:$E$11)),0))	=INDEX($B$2:$B$11,MATCH(1,(I6=$C$2:$C$11)*((J6>=$D$2:$D$11)*(J6<=$E$2:$E$11)),0))
7	1200	Depreciation	00	4360	4365
8	1200	Depreciation	00	5245	5245
9	1300	Mfg Costs 3	05	4370	4699
10	1300	Mfg Costs 3	05	4701	4999
11	1400	Facility Insurance	04	4700	4700

Sheet: Initial