How to space =Filter by row and return TRUE

[Mooncake1]

hi friends

I have another addon to my sheet that im looking to sort.

i would like to return a TRUE on each row where the =filter match exists (don't know how) against the criteria in col A

here is an example sheet of what it will look like

Book1.xlsx
	A	B	C	D	E	F	G	H	I
1			Not ideal.		Wanting to do this
2	Hardcode list match?		Yes or no	Sequence	Yes or no	Sequence		Changing List	Sequence
3	Joe		Ben	8				58fdghj 32	1
4	George		Dan	13				1dfsh 23	2
5	Gladys							Diesel 11	3
6	Ben							74dgfh 22	4
7	Barry							142dgfh 457	5
8	Bonk							156jg 65754	6
9	Bob							98hj 4	7
10	Dan				TRUE	8		Ben	8
11	Diesel							170fgh 546	9
12	Dustin							Joe 78	10
13								Barry 79	11
14								16tyh 82	12
15					TRUE	13		Dan	13
16								16tyh 84	14
17								16tyh 85	15
18								Dan 86	16
Sheet1

Cell Formulas
Range	Formula
C3:D4	C3	=FILTER(H3:I18, COUNTIF(A3:A12, H3:H18))
Dynamic array formulas.

anyone know how?

 

[Peter_SSs]

Would this, entered into E3 only, be any good?

21 09 20.xlsm
	A	B			E	F	G	H	I
1					Wanting to do this
2	Hardcode list match?				Yes or no	Sequence		Changing List	Sequence
3	Joe							58fdghj 32	1
4	George							1dfsh 23	2
5	Gladys							Diesel 11	3
6	Ben							74dgfh 22	4
7	Barry							142dgfh 457	5
8	Bonk							156jg 65754	6
9	Bob							98hj 4	7
10	Dan				Ben	8		Ben	8
11	Diesel							170fgh 546	9
12	Dustin							Joe 78	10
13								Barry 79	11
14								16tyh 82	12
15					Dan	13		Dan	13
16								16tyh 84	14
17								16tyh 85	15
18								Dan 86	16
Sheet2 (2)

Cell Formulas
Range	Formula
E3:F18	E3	=IF(COUNTIF(A3:A12,H3:H18),H3:I18,"")
Dynamic array formulas.

 

[Fluff]

How about in E3

=IF(ISNUMBER(MATCH(H3:H18,A3:A12,0)),TRUE,"")

 

[Peter_SSs]

Would this, entered into E3 only, be any good?

If you actually want the TRUE instead of names then

21 09 20.xlsm
	A	B			E	F	G	H	I
1					Wanting to do this
2	Hardcode list match?				Yes or no	Sequence		Changing List	Sequence
3	Joe							58fdghj 32	1
4	George							1dfsh 23	2
5	Gladys							Diesel 11	3
6	Ben							74dgfh 22	4
7	Barry							142dgfh 457	5
8	Bonk							156jg 65754	6
9	Bob							98hj 4	7
10	Dan				TRUE	8		Ben	8
11	Diesel							170fgh 546	9
12	Dustin							Joe 78	10
13								Barry 79	11
14								16tyh 82	12
15					TRUE	13		Dan	13
16								16tyh 84	14
17								16tyh 85	15
18								Dan 86	16
Match Names

Cell Formulas
Range	Formula
E3:F18	E3	=IF(COUNTIF(A3:A12,H3:H18),CHOOSE({1,2},TRUE,I3:I18),"")
Dynamic array formulas.