Copy paste match of the horizontal "header patterns"

[Kishan]

Hi,</SPAN></SPAN>

Data column is column C:E</SPAN></SPAN>

Header H2:I4 values are brought by formula and J2:J4 values are consonants </SPAN></SPAN>
Header-1 H2:J2 = Pattern XX1</SPAN></SPAN>
Header-2 H3:J3 = Pattern XXX</SPAN></SPAN>
Header-3 H4:J4 = Pattern XX2</SPAN></SPAN>

I want that look each header pattern in the column C, D & E if header match found then copy the pattern and paste in their corresponding row in the column H, I & J as shown below in example</SPAN></SPAN>

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1
2								X	X	1
3								X	X	X
4								X	X	2
5			P1	P2	P3			P1	P2	P3
6			X	1	1
7			X	X	2			X	X	2
8			X	1	1
9			1	1	1
10			X	X	1			X	X	1
11			1	1	1
12			X	X	1			X	X	1
13			2	1	1
14			1	X	X
15			X	1	1
16			X	2	1
17			X	1	2
18			1	1	1
19			X	X	X			X	X	X
20			2	X	2
21			X	X	1			X	X	1
22			X	X	1			X	X	1
23			1	1	X
24			1	1	1
25			2	X	1
26			X	X	1			X	X	1
27			1	1	X
28			1	X	1
29			1	1	X
30			1	X	1
31			X	X	2			X	X	2
32			2	1	X
33			X	X	2			X	X	2
34			1	X	2
35			X	2	X
36			2	1	1
37			1	1	1
38			1	X	2
39			X	X	1			X	X	1
40			X	X	X			X	X	X
41			X	X	2			X	X	2
42			1	1	2
43			X	1	1
44			1	1	1
45			2	X	1
46			1	1	X
47			1	1	1
48			1	1	1
49			2	X	2
50			2	1	X
51			1	1	1
52			X	1	2
53			1	X	2
54
55
56
Sheet18

Thank you in advance</SPAN></SPAN>

Using Excel 2000</SPAN></SPAN>

Regards,</SPAN></SPAN>
Kishan</SPAN></SPAN>

 

[Rick Rothstein]

You can do what you asked for with a simple formula. Put this formula in cell H6 and copy it across to cell J6, then copy those three cells (H6:J6) down to the bottom of your data...

=IF(AND($C6="X",$D6="X"),C6,"")

 

[Kishan]

You can do what you asked for with a simple formula. Put this formula in cell H6 and copy it across to cell J6, then copy those three cells (H6:J6) down to the bottom of your data...

=IF(AND($C6="X",$D6="X"),C6,"")

Rick, thank you for the formula it is giving a desire result as per post#1 given example</SPAN></SPAN>

But may I want a formula to be linked with the header patterns because header patterns are not fixed all the time it can be changing like as H2:J2 = 1X1, H3:J3 = 1X2, H4:J4 = 1X2 or it can be like as H2:J2 = 211, H3:J3 = 212, H4:J4 = 212 does it is possible to formula could work within all situations </SPAN></SPAN>

Kind Regards,</SPAN></SPAN>
kishan </SPAN></SPAN>

 

[Rick Rothstein]

Okay, give this more general formula a try...

=IF(OR($C6&$D6&$E6=$H$2&$I$2&$J$2,$C6&$D6&$E6=$H$3&$I$3&$J$3,$C6&$D6&$E6=$H$4&$I$4&$J$4),C6,"")

 

[Kishan]

Okay, give this more general formula a try...

=IF(OR($C6&$D6&$E6=$H$2&$I$2&$J$2,$C6&$D6&$E6=$H$3&$I$3&$J$3,$C6&$D6&$E6=$H$4&$I$4&$J$4),C6,"")

Rick, it is a superb working perfect with every change in the header patterns. </SPAN></SPAN>

I do appreciate for your kind help</SPAN></SPAN>

Kind Regards,</SPAN></SPAN>
Kishan </SPAN></SPAN>