right , left , search, find

[vmjan02]

I tried every possibe way but stuck, this task is taking me 6 hrs any better way to close this ecel 2016.

Output screen shot

Input Remarks.

Book3
	A	B	C	D	E	F	G
1	For OutPut 1		For OutPut 2 from Input 2 (red colour as result)		For OutPut 3 from Input 2 (blue colour as result)		For OutPut 4 from Input 1 (red colour as result)
2	all the data before : from input 1		R1.S1.LT12.CP1 ( XGS CG1.SCG1 ( ) )		R1.S1.LT12.CP1 ( XGS CG1.SCG1 ( ) )		114-00_MNARRD00OLA:CG1.SCG1.ONT1
3			R1.S1.LT8.CP4 ( XGS CG4.SCG1 ( ) )		R1.S1.LT11.CP117 ( XGS CG7.SCG1 ( ) )		114-00_MNARRD00OLA:CG3.SCG1.ONT113
Sheet1

I have this input table and looking for the outputs

Book1
	A	B	C	D	E	F	G
1	Input 1	Input 2		Output 1	OutPut 2	OutPut 3	OutPut 4
2	114-00_MNARRD00OLA:CG1.SCG1.ONT1	R1.S1.LT12.CP1 ( XGS CG1.SCG1 ( ) )		114-00_MNARRD00OLA	12	1	1
3	114-00_MNARRD00OLA:CG1.SCG1.ONT2	R1.S1.LT12.CP1 ( XGS CG1.SCG1 ( ) )		114-00_MNARRD00OLA	12	1	2
4	114-00_MNARRD00OLA:CG1.SCG1.ONT3	R1.S1.LT7.CP1 ( XGS CG1.SCG1 ( ) )		114-00_MNARRD00OLA	7	1	3
5	114-00_MNARRD00OLA:CG1.SCG1.ONT4	R1.S1.LT12.CP1 ( XGS CG1.SCG1 ( ) )		114-00_MNARRD00OLA	12	1	4
6	114-00_MNARRD00OLA:CG2.SCG1.ONT1	R1.S1.LT12.CP2 ( XGS CG2.SCG1 ( ) )		114-00_MNARRD00OLA	12	2	1
7	114-00_MNARRD00OLA:CG3.SCG1.ONT1	R1.S1.LT12.CP3 ( XGS CG3.SCG1 ( ) )		114-00_MNARRD00OLA	12	3	1
8	114-00_MNARRD00OLA:CG3.SCG1.ONT2	R1.S1.LT12.CP3 ( XGS CG3.SCG1 ( ) )		114-00_MNARRD00OLA	12	3	2
9	114-00_MNARRD00OLA:CG3.SCG1.ONT113	R1.S1.LT12.CP3 ( XGS CG3.SCG1 ( ) )		114-00_MNARRD00OLA	12	3	113
10	205-00_SLMHKH00OLQ:CG1.SCG1.ONT1	R1.S1.LT8.CP4 ( XGS CG4.SCG1 ( ) )		205-00_SLMHKH00OLQ	8	4	1
11	205-00_SLMHKH00OLQ:CG1.SCG1.ONT12	R1.S1.LT12.CP4 ( XGS CG4.SCG1 ( ) )		205-00_SLMHKH00OLQ	12	4	12
12	205-00_SLMHKH00OLQ:CG1.SCG1.ONT3	R1.S1.LT12.CP4 ( XGS CG4.SCG1 ( ) )		205-00_SLMHKH00OLQ	12	4	3
13	205-00_SLMHKH00OLQ:CG17.SCG1.ONT1	R1.S1.LT1.CP5 ( XGS CG5.SCG1 ( ) )		205-00_SLMHKH00OLQ	1	5	1
14	205-00_SLMHKH00OLQ:CG17.SCG1.ONT118	R1.S1.LT11.CP5 ( XGS CG5.SCG1 ( ) )		205-00_SLMHKH00OLQ	11	5	118
15	205-00_SLMHKH00OLQ:CG17.SCG1.ONT3	R1.S1.LT11.CP15 ( XGS CG5.SCG1 ( ) )		205-00_SLMHKH00OLQ	11	15	3
16	205-00_SLMHKH00OLQ:CG17.SCG1.ONT4	R1.S1.LT11.CP16 ( XGS CG6.SCG1 ( ) )		205-00_SLMHKH00OLQ	11	16	4
17	223-00_AZIZKH00OL7:CG29.SCG1.ONT2	R1.S1.LT11.CP16 ( XGS CG6.SCG1 ( ) )		223-00_AZIZKH00OL7	11	16	2
18	223-00_AZIZKH00OL7:CG3.SCG1.ONT18	R1.S1.LT116.CP6 ( XGS CG6.SCG1 ( ) )		223-00_AZIZKH00OL7	116	6	18
19	223-00_AZIZKH00OL7:CG3.SCG1.ONT2	R1.S1.LT11.CP117 ( XGS CG7.SCG1 ( ) )		223-00_AZIZKH00OL7	11	117	2
20	223-00_AZIZKH00OL7:CG30.SCG1.ONT1	R1.S1.LT11.CP17 ( XGS CG7.SCG1 ( ) )		223-00_AZIZKH00OL7	11	17	1
21	223-00_AZIZKH00OL7:CG30.SCG1.ONT2	R1.S1.LT11.CP7 ( XGS CG7.SCG1 ( ) )		223-00_AZIZKH00OL7	11	7	2
22	114-00_MNARRD00OLA:CG7.SCG1.ONT14	R1.S1.LT11.CP7 ( XGS CG7.SCG1 ( ) )		114-00_MNARRD00OLA	11	7	14
23	114-00_MNARRD00OLA:CG8.SCG1.ONT18	R1.S1.LT11.CP8 ( XGS CG8.SCG1 ( ) )		114-00_MNARRD00OLA	11	8	18
24	205-00_SLMHKH00OLQ:CG1.SCG1.ONT201	R1.S1.LT16.CP1 ( XGS CG1.SCG1 ( ) )		205-00_SLMHKH00OLQ	16	1	201
Sheet1

 

[vmjan02]

any way out for this

 

[RoryA]

Please don't bump your own post after less than 30 minutes!

What exactly have you tried?