List all order numbers that have Item number value

[campos1578]

Hey Guys,

I've been trying to find the right formula practically all day.

I've randomly generated Items Numbers and Order Numbers from a separate worksheet and Copy/Pasted into this worksheet.
Column A has item numbers which may repeat. Column B also has Order Numbers that may repeat. Column C is using the vlookup reference from a different worksheet

My intent: Find the maximum number of Item numbers that appear in the maxim amount of Order Numbers and return in a list

Examples
1 - Run formula that finds the maximum combination of Item numbers that appear in the maxim amount of Order Numbers and return in a list
1- Type an Item Number into cell E2 and generate a list of Order numbers which have that item number from column A vertically starting at F2.
2 -Type in 1 item number in E2 or type in multiple Item numbers (Possibly D2 and E2) and return list of orders that match the criteria for two

I want to input a number in cell E2

 

[AhoyNC]

Maybe something like this:

Book2
	A	B	C	D	E	F	G
1	Item Num	Order Num	Item Description	Item number	Item number	Order Num	Item Description
2	10801127	1	Cool Whip Extra Creamy Whipped Cream Topping, 8 oz Tub	10801127	23554586	1	Cool Whip Extra Creamy Whipped Cream Topping, 8 oz Tub
3	23554586	1	OREO Double StufChocoIate Sandwich Cookies, Family Size, 20 oz			1	OREO Double StufChocoIate Sandwich Cookies, Family Size, 20 oz
4	50228527	1	Great Value Baked Buttery Round *******s, 3.7 oz			1	Great Value Marshmallows, 0 oz
5	10421746	1	RINGS HAWAIIAN Savory Butter Rolls, 2 Pack
6	29209893	1	G-S Classic Bologna Sliced Deli-Style Lunch Meat, 0 Slices Per Package, 2 Ounce Pack
7	51259212	1	Yellow Onions, Each
8	44391605	1	Eresh Strawberries, b
9	24269942	1	Great Value Cauliflower, 2 oz (Frozen)
10	981077201	1	5remium Grape Tomato, 0 oz Package
11	287905711	1	Great Value Chopped Pecans, 4 oz
12	23554586	1	Great Value Marshmallows, 0 oz
13	100546946	1	hyson All Natural, Fresh, Boneless, Skinless Chicken Breasts, 2.5 • 4.0 b
14	1081.3483	1	hotino's Party Pizza, Combination, Frozen Snacks, 0.7 oz, ct
15	305034339	1	freshness Guaranteed Homestyle Breaded Chicken Sandwich
16	287474410	1	hasteful Selections Honey Gold Potatoes, 24 Oz.
17	10450.339	1	Great Value Ultra-pasteurized Real Heavy Whipping Cream, 6 Oz
18	808179972	1	br Pepper Zero Sugar Soda, 20 fl oz bottle
Sheet1

Cell Formulas
Range	Formula
F2:G4	F2	=FILTER($B$2:$C$18,($A$2:$A$18=E2)+($A$2:$A$18=D2),"No Match")
Dynamic array formulas.