Pass multiple values to FILTER formula

[Todd_S]

Hi. Is there a way I can pass a list of 30 values to a FILTER formula, so that it works like an OR formula? In other words, I want to pick every sale of the item number (from a long list of items) that match this list of thirty. I'm thinking of something like using curly brackets within a SUMIFS formula to act like "OR".

Thanks in advance.

 

[Fluff]

Do you mean like

+Fluff New.xlsm
	E	F	G	H	I	J
1	District	Ward
2	Test Valley	Cupernham		Swindon		Coton
3	Hackney	Lea Bridge		Stafford		Gorse Hill and Pinehurst
4	East Hertfordshire	Hertford Castle		Newham		Checkley
5	Stafford	Coton		Blaby		Hounslow Central
6	North Tyneside	Longbenton				Plaistow South
7	Nottingham	Bulwell				Cosby with South Whetstone
8	Swindon	Gorse Hill and Pinehurst				Bingham East
9	Swindon	Checkley				Tidworth
10	High Peak	Simmondley
11	Hinckley and Bosworth	Groby
12	Stockton-on-Tees	Grangefield
13	Newham	Hounslow Central
14	Horsham	Steyning
15	Newham	Plaistow South
16	North East Lincolnshire	Heneage
17	Windsor and Maidenhead	Boyn Hill
18	Leicester	Wycliffe
19	Sheffield	Shiregreen and Brightside
20	Elmbridge	Cobham and Downside
21	Blaby	Cosby with South Whetstone
22	Birmingham	Springfield
23	Blaby	Bingham East
24	East Northamptonshire	Thrapston Lakes
25	Tamworth	Glascote
26	Swindon	Tidworth
27	St. Helens	Newton
Data

Cell Formulas
Range	Formula
J2:J9	J2	=FILTER(F2:F27,ISNUMBER(MATCH(E2:E27,H2:H5,0)))
Dynamic array formulas.

 

[Todd_S]

Yes, that seems to have worked perfectly! Thank you so much. I'm going to step through it in Evaluate Formulas because I'm a bit stumped into how it's working.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Todd_S]

Loved this trick so much I used it in a different workbook where I'm picking out employees and needed to exclude certain job titles. Shortened the formula from:

to:

Thanks again!

 

[Fluff]

My pleasure & glad you could understand it.