Multiple Matches and lookups for a defined criteria

[fnurk]

Dear Excel Experts!

I really need your help

I have an excel file with many different orders. In the order two things are important: values in column C ASHEET (ending on A) and values in column D (components of Asheets). Now i need to analyse whether the component of an order is on ONE of the values in column C per order. If this is the case then TRUE else FALSE.

NOTE: there are different ASHEETS per order, the COMPONENT only need one match with one of the ASHEETS in sheet 2
NOTE II: Formula should include the order type, since we only want to look for a single
NOTE III: There are >50.000 rows to analyse
Note IV: I'm using Excel 2013

Thanks! [example file attached]

Fnurk

---------------------------------------------------

Example:
SHEET 1
[TABLE="width: 649"]
<tbody>[TR]
[TD]ORDER [A][/TD]
[TD]MATERIAL[/TD]
[TD]ASHEET [C][/TD]
[TD]COMPONENT [D][/TD]
[TD]EXAMPLE OUTPUT [E][/TD]
[/TR]
[TR]
[TD]9900388225[/TD]
[TD]4022.451.99211[/TD]
[TD][/TD]
[TD]4022.451.99211[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]9900388225[/TD]
[TD]4022.480.51255[/TD]
[TD]4022.480.51259A[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9900388225[/TD]
[TD]4022.480.51256[/TD]
[TD]4022.480.51256A[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9900388225[/TD]
[TD]4022.480.51256FSD[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

SHEET 2
[TABLE="width: 388"]
<tbody>[TR]
[TD]Asheet [A][/TD]
[TD]Factory part[/TD]
[TD]Component quantity [C][/TD]
[/TR]
[TR]
[TD]4022.480.51204A[/TD]
[TD]4022.451.99211[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4022.480.51205A[/TD]
[TD]4022.451.99211[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4022.480.51206A[/TD]
[TD]4022.451.99211[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4022.480.51254A[/TD]
[TD]4022.451.99211[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4022.480.51255A[/TD]
[TD]4022.451.99211[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4022.480.51256A[/TD]
[TD]4022.451.99211[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]