EXCEL FORMULA TO HAVE A DYNAMIC FILTER "DROPDOWN LIST"

[blackorchids2002]

Hi Masters,

I need a dropdown list formula to show the items available if any word that will hit in Item Name column.
Example: Chicken Tenders
I need to see in column B all the items that will hit chicken or tenders to see the options what item to buy. If this is not possible because some are not using Office 365. It will be easier if some have Office 365 so I can use the "FILTER" excel formula.

RECIPE COSTING (INITIAL).xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1		SMB BAR
2
3
4			CATEGORY	KIDS MENU
5
6			DATE	January 19, 2022
7
8			PRODUCT NAME	KIDS CHICKEN TENDERS
9
10			SUGGESTED SELLING PRICE	$ 8.50
11
12			TOTAL RECIPE COST	$ 1.37
13
14			FOOD COST MARGIN	% 16.11
15
16			NET PROFIT	$ 7.13
17												UOM
18
19			INGREDIENTS				PICTURE					Imperial
20		ITEM LIST	Item Name	Qty. Oz	Cost (per unit)	Total Cost
21		CHIC TENDER TYSON HMSTYL 2-5LBS	CHCIKEN TENDERS	4	$ 0.24	$ 0.96
22		F/F POTATO CUT 3/ 8 5LB	FRIES	4	$ 0.06	$ 0.26
23		KENS DIJ HONEY MTARD DRESS 4-1G	HONEY MUSTARD DRESSING	2	$ 0.08	$ 0.15
24
25
26
27
28
29
30			TOTAL			$ 1.37
31
RECEIPE COSTING

Cell Formulas
Range	Formula
D12	D12	=F30
D14	D14	=IF(D12="","",IF(ISBLANK(D10),"",D12/D10))
D16	D16	=D10-D12
E21:E23	E21	=VLOOKUP(B21,'ITEM LIST'!A:L,12,0)
F21:F29	F21	=IF(OR(ISBLANK(D21),ISBLANK(E21)),"",E21*D21)
F30	F30	=IF(SUM(F21:F29)=0,"",SUM(F21:F29))

Named Ranges
Name	Refers To	Cells
'ITEM LIST'!_FilterDatabase	='ITEM LIST'!$A$1:$P$1603	E21:E23
ITEMLIST	='ITEM LIST'!$A:$A	E21:E23

Cells with Data Validation
Cell	Allow	Criteria
L19:M19	List	Imperial, Metric
B21:B29	List	=ITEMLIST

Thanks,
Blackorchids