Index/Match Non-linear Logic

[JPARKHURST]

I have the following table structure.

I am attempting to pull in the Planning rate associated with the Part No.

The structure (if you look towards the bottom of my table) is not stable - sometimes a product may have 1, 2 or 3 lines (they could, conceivably, have 10).
The structure may have
Part # Paint E-Coat 0
Assy LINENAMEVARIABLE Pack NEEDED RATE

- It will not always have a Paint E-Coat, and it may often have Multiple workstatiosn (eg, Assy LINENAMEVARIABLE Pack; Assy ReSpray LINE NAME VARIABLE PACK)
- Paint will always come first, if it exists, in the listing.

This is the formula I am using. Does it look valid? I am seeing a few results which I question, but so far each one I have looked at looks valid. That being said, there are several thousand Part#'s, so I cannot obviously track and check all of them (ok, I can, I don't want to).

Basically - how's my logic hold up, or can anybody see a better way of doing this? It feels...jinky.

=IF((INDEX(Master!J:J,MATCH(Derived!A2,Master!A:A,0)))="Paint E-Coat",INDEX(Master!L:L,SUM(MATCH(A2,Master!A:A,0)+1)),INDEX(Master!L:L,MATCH(A2,Master!A:A,0)))

(sorry about the sloppy table, i'm limited on what i can upload, transfer (apparently copy). I put the column letters/lables in the first row when I could no longer put them above.

A B C D E F G H I

Part No	Name	Rev	Standard Job Quantity	Scrap (%)	Lead Time Days	Daily Pull Quantity	Op No	Operation	Approved Workcenters (column J)	Setup (hrs)	Planning Rate (pcs/hr) (Column L)
100277-91131511-7	5 DWR TOOL CENTER BLACK		0	0	0	0	10	Paint E-Coat	Paint E-Coat	0.15	0
							30	Assembly Simplified FG Packing	Assy AMS TC Pack	0.15	97
									ASSY RESPRAY PACK	0.15	97
100807-10131	WALL CABINET RTA RB		0	0	0	0	10	Paint E-Coat	Paint E-Coat	0.15	0
							40	Assembly Simplified FG Packing	Assy GS 1 Pack	0.15	65
									Assy GS PRO Pack	0.15	65
100875-10132	WORKBENCH 6FT RTA RED		0	0	0	0	10	Paint E-Coat	Paint E-Coat	0.15	0
							40	Assembly Simplified FG Packing	Assy GS 1 Pack	0.15	52
									Assy GS PRO Pack	0.15	52
100879-10133	WORKBENCH 5 DRAWER KIT RTA RB		0	0	0	0	10	Paint E-Coat	Paint E-Coat	0.15	0
							30	Assembly Simplified FG Packing	Assy GS 1 Pack	0.15	70
									Assy GS PRO Pack	0.15	70
100964-10134	FLOOR CABINET RB RTA		0	0	0	0	10	Paint E-Coat	Paint E-Coat	0.17	0
							20	Paint E-Coat 1	Paint E-Coat	0.17	0
							40	Assembly Simplified FG Packing	Assy GS 1 Pack	0.17	50
									Assy GS PRO Pack	0.17	50
									ASSY RESPRAY PACK	0.17	50
101038-PC343	3 DWR PROJ CTR RR		0	0	0	0	10	Paint E-Coat	Paint E-Coat	0.15	0
							40	Assembly Simplified FG Packing	Assy AMS Cab Pack	0.15	121
101271-10139	WORKBENCH 5 DRAWER KIT RTA BP		0	0	0	0	10	Paint E-Coat	Paint E-Coat	0.12	0

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>