Search Array for Exact value and return specific columns from searched array and ONLY rows that match actual search value

[Kerryx]

As you can see having major brain issue this morning, want to search array for "P1" but getting all rows starting with "P1" returning, how can i get only rows containing "P1" to return, not the "P12" or "P13" and so on.

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	SKU	TEST	Method	Min	Max		P1
2	P1	pH	Meter	4.5	6.5			P1	pH	4.5	6.5
3	P1	Colour	Clr	1	2.2			P1	Colour	1	2.2
4	P1	Flavour	Flv	5.5	6.5			P1	Flavour	5.5	6.5
5	P1	Salt	NaCl	1.5	2.5			P1	Salt	1.5	2.5
6	P1	Fat	Gerb	45.5	50.5			P1	Fat	45.5	50.5
7	P2	pH	Meter	5.1	6.1			P12	Fat	45	65
8	P2	Colour	Clr		6.5			P12	pH	6.5	7
9	P2	Flavour	Flv		6			P12	Colour	6.2	7.2
10	P2	Salt	NaCl	1	2.5			P12	Flavour	0	6.2
11	P12	Fat	Gerb	45	65			P12	Salt	1.2	2.3
12	P12	pH	Meter	6.5	7
13	P12	Colour	Clr	6.2	7.2
14	P12	Flavour	Flv		6.2
15	P12	Salt	NaCl	1.2	2.3
16	P21	Fat	Gerb	25	35
17	P21	pH	Meter	6.5	7.4
18	P21	Colour	Clr	4.5	6.7
19	P21	Flavour	Flv		7
20	P21	Salt	NaCl	2.5	3.5
21	P22	Fat	Gerb	22.5	33.5
Sheet1

Cell Formulas
Range	Formula
H2:K11	H2	=CHOOSECOLS(FILTER($A$2:$E$21,ISNUMBER(SEARCH($G$1,$A$2:$A$21))),{1,2,4,5})
Dynamic array formulas.

 

[Fluff]

How about

=CHOOSECOLS(FILTER($A$2:$E$21,$A$2:$A$21=G1),{1,2,4,5})

 

[Kerryx]

You're a star Fluff, me head was wrecked over this ......

 

[Fluff]

You're welcome & thanks for the feedback.