Filtering based on list of numbers

[HorseMcHorse]

I am trying to create a function to filter a table based on whether a column contains a certain number. This column contains numbers separated by /. Like so:

Using Excel 2016, I am attempting to create a function to filter it based on a different cell containing that number. I.e., the following would be produced:

Or,

I attempted at first to simply find the value, however, am unsure how to deal with the / separators, and with recognizing "2" as distinct from, say, "12" or "20", without simply encoding all single digit values differently. I would appreciate any pointers, with a mind that this is using Excel 2016.

 

[Peter_SSs]

Welcome to the MrExcel board!

See if this helps.
(It may be that in your version you may need to confirm the formula with Ctrl+Shift+Enter, not just Enter before copying down/across.)

23 05 09.xlsm
	A	B	C	D	E	F	G	H	I
1				Filter on:	2			46
2	A	2			A	2		C	46/2/30
3	B	2/20			B	2/20		D	46/23
4	C	46/2/30			C	46/2/30
5	D	46/23
6
Filter

Cell Formulas
Range	Formula
E2:F5	E2	=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($B$2:$B$5)/ISNUMBER(FIND("/"&$E$1&"/","/"&$B$2:$B$5&"/")),ROWS(E$2:E2))),"")
H2:I5	H2	=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($B$2:$B$5)/ISNUMBER(FIND("/"&$H$1&"/","/"&$B$2:$B$5&"/")),ROWS(H$2:H2))),"")