Search data ranges, compare data sets, publish differences.

[sonofthunder07]

Hello,
I am looking for a single formula solution that searches the concatenated values of columns A & B for entries that do not match the concatenated values of: cell D1 and Range C4:C11, or E1 and Range C4:C11, and put the results in a list in column C from range C14:C30 as shown in the screen shot.
Thanks,
Ken

Excel Workbook
	A	B	C	D	E
1	Work Order	Sqwk	W/O	G1348	G1348I
2	G1348	105	STATUS AS OF:		06/03/11
3	G1348	105	SQK-100	PERFORM THE F/P EFFORT AS FOLLOWS FOR LH OUTBOARD AILERON:
4	G1348	110	105	CHECK ID & VERIFY PART NUMBER
5	G1348	115	110	DISASSEMBLE FOR STRIP
6	G1348	115	115	STRIP EXTERIOR
7	G1348	121	120	INSPECT STEEL FASTENERS FOR RUST & CORROSION
8	G1348	125	125	TOUCH-UP STEEL FASTENERS
9	G1348	125	130	REMOVE UPPER SURFACE PANELS
10	G1348	130	135	REVIEW AFTO FORM 103
11	G1348	135	140	INSPECT THE AILERON
12	G1348	135	SQK-100	Total
13	G1348	140	W/O & Sqwk	MIS-CHARGED TIME
14	G1348I	105	G1348121
15	G1348I	110	G1348I1359
16	G1348I	110
17	G1348I	115
18	G1348I	115
19	G1348I	115
20	G1348I	120
21	G1348I	125
22	G1348I	130
23	G1348I	130
24	G1348I	139
25	G1348I	140
26	G1348I	140
Sheet1

Excel 2007

 

[sonofthunder07]

Correction:
Cell C15 should read "G1348I139"
Thanks

 

[sonofthunder07]

Hello,
Any takers on solving this formula challenge?
Thanks for any help you can provide.