Array Function with Multiple, Variable, Dependent Criteria, Write Destination

I have a spreadsheet showing orders and manufacturing locations. Each order is broken down to the line level and the point of manufacture is shown for each line. I need to write a formula which will (a) check the "Order No" column for all occurences of each order number, then (b) find the first "POM Number" record associated with that order number, (c) determine if all POM instances for that Order match the first instance and (d) if so, write a "1" in column "Direct," else leave it blank (or write a "0" if something must be written).

Direct POM Number Code Agent Order No (columns continue)
1 040 129XY1 2000 90023A
1 040 129XY1 2000 90023A
_ 052 856G02 2000 90028A
_ 040 129XY1 2000 90028A
_ 052 856G02 2000 90028A


The actual match is dependent on whether or not all POM cells for any given PO match each other. I don't want any of the records flagged if any single POM location for that order differs.

The source file varies daily in the number of records, depending on how many orders are pending. (Today's file was about 7000 lines). The lines on an order will vary, depending on what we have in backlog. POM locations vary within a range of about 20 different locations. I'm trying to write a function that can simply be copied down as needed.

I've tried nesting within a plain IF statement as follows: {=IF(SUM(($B$23:$B$5=B4)*($E$2:$E$23=C4)),1,0)}, but it returns a "1" every time - because, of course, cells always match themselves. I started to try a nested IF with a VLOOKUP, but that doesn't seem feasible. Since the data is dynamic, an INDEX (or other static location) call doesn't seem like it would work, either.

Obviously, I'm missing something, but I don't know what.

I am running Excel 2003 and have attached a small example file.

I have searched but been unable to find anything similar dealing with dependent variables. Please point me in the right direction if I missed it. Any help at all would be greatly appreciated.

Not entirely sure I follow ...

I think for ex. in your sample A20:A23 should be 0 rather than 1 given 90032A is located in rows 11 & 12 with different POM, no ?
(they are highlighted yellow which based on results I am assuming means you expect a result of 1 ?)

If the above assumption is correct (ie oversight in sample file), one approach:

A2:
=IF(COUNTIF($E$1:$E2,$E2)=1,--(SUMPRODUCT(--($E3:E$100=$E2),--($B3:B$100<>$B2))=0),INDEX($A$1:$A1,MATCH($E2,$E$1:$E1,0)))
copied down

Modify ranges to suit but keep as lean as possible given use of SUMPRODUCT.

Note that in the above the SUMPRODUCT is calculated only once per OrderNo.
Subsequent instances of a given OrderNo use that prior result rather than recalculating (it is an expensive calculation)