FILTER function include argument limitations w

[Nobes]

Hello is it it possible to use a reference to a spilled array as the criteria in the include argument in the FILTER function ? Each time I try to do this it returns an N/A# error.

 

[KRice]

It is possible, but some additional details are needed to offer better assistance. Here is one example:

MrExcel_20230523.xlsx
	A	B	C	D
1			Filtered Results	Spilled Array Criteria
2	45	a	b	1
3	2	b	d	2
4	34	c	f	3
5	1	d		4
6	45	e
7	3	f
8	13	g
Sheet12

Cell Formulas
Range	Formula
C2:C4	C2	=FILTER(B2:B8,ISNUMBER(MATCH(A2:A8,D2#,0)))
D2:D5	D2	=SEQUENCE(4)
Dynamic array formulas.