Displaying multiple matches based on multiple criteria.

[Joe Rdz]

Hi, so I've been looking around for a kind of self-project that I have in mind. I got a list of different descriptions with variable components, basically my idea is: if I have a certain amount of this component and a certain amount of this other component, display all the matches based on the criteria AND quantity needed (Because of the available material).

Excel 2016 (Windows) 64 bit
[TABLE="class: head"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]
[TH][/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]A[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]B[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]C[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]D[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]E[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]F[/COLOR]​

[/TH]
[TH]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]G[/COLOR]​

[/TH]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]1[/COLOR]​

[/TD]
[TD]

Mounting ​

[/TD]
[TD]

Qty Required ​

[/TD]
[TD]

Description​

[/TD]
[TD]

Color​

[/TD]
[TD][/TD]
[TD]Mouting
[/TD]
[TD]

IS​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]2[/COLOR]​

[/TD]
[TD]

STD​

[/TD]
[TD]

1​

[/TD]
[TD] RSX1 LED P1 40K R4 HVOLT WBA DBLXD
[/TD]
[TD] DBLXD
[/TD]
[TD][/TD]
[TD]Quantity
[/TD]
[TD]

50​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]3[/COLOR]​

[/TD]
[TD]

IS​

[/TD]
[TD]

2​

[/TD]
[TD] RSXF1 LED P4 50K WFL 240 IS PEX FAO DDBXD
[/TD]
[TD] DDBXD
[/TD]
[TD][/TD]
[TD]Color
[/TD]
[TD]

DDBXD​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]4[/COLOR]​

[/TD]
[TD]

STD​

[/TD]
[TD]

48​

[/TD]
[TD] RSX1 LED P4 50K R3 MVOLT SPA DNAXD
[/TD]
[TD] DNAXD
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]5[/COLOR]​

[/TD]
[TD]

IS​

[/TD]
[TD]

8​

[/TD]
[TD] RSXF2 LED P4 40K WFL MVOLT IS DNAXD
[/TD]
[TD] DNAXD
[/TD]
[TD][/TD]
[TD]Mouting
[/TD]
[TD]

IS​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]6[/COLOR]​

[/TD]
[TD]

IS​

[/TD]
[TD]

2​

[/TD]
[TD] RSXF1 LED P4 50K WFL MVOLT IS PE DWHXD
[/TD]
[TD] DWHXD
[/TD]
[TD][/TD]
[TD]Quantity
[/TD]
[TD]

30​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]7[/COLOR]​

[/TD]
[TD]

IS​

[/TD]
[TD]

53​

[/TD]
[TD] RSXF1 LED P4 50K WFL MVOLT IS PE FAO DDBXD
[/TD]
[TD] DDBXD
[/TD]
[TD][/TD]
[TD]Color
[/TD]
[TD]

DNAXD​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]8[/COLOR]​

[/TD]
[TD]

STD​

[/TD]
[TD]

9​

[/TD]
[TD] RSX1 LED P1 40K R3 240 HS SPA NLTAIR2 PIRHN DDBXD
[/TD]
[TD] DDBXD
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]9[/COLOR]​

[/TD]
[TD]

STD​

[/TD]
[TD]

5​

[/TD]
[TD] RSX2 LED P2 40K R5 240 SPA NLTAIR2 PIRHN DDBXD
[/TD]
[TD] DDBXD
[/TD]
[TD][/TD]
[TD]Mouting
[/TD]
[TD]

STD​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]10[/COLOR]​

[/TD]
[TD]

IS​

[/TD]
[TD]

10​

[/TD]
[TD] RSXF2 LED P6 50K WFL MVOLT IS FAO DDBXD
[/TD]
[TD] DDBXD
[/TD]
[TD][/TD]
[TD]Quantity
[/TD]
[TD]

60​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]11[/COLOR]​

[/TD]
[TD]

IS​

[/TD]
[TD]

16​

[/TD]
[TD] RSXF2 LED P6 50K WFL MVOLT IS FAO DDBXD
[/TD]
[TD] DDBXD
[/TD]
[TD][/TD]
[TD]Color
[/TD]
[TD]

DDBXD​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]12[/COLOR]​

[/TD]
[TD]

IS​

[/TD]
[TD]

12​

[/TD]
[TD] RSXF1 LED P4 40K WFL MVOLT IS FAO DDBXD
[/TD]
[TD] DDBXD
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]13[/COLOR]​

[/TD]
[TD]

STD​

[/TD]
[TD]

2​

[/TD]
[TD] RSX1 LED P1 40K R4 MVOLT HS SPA DDBXD
[/TD]
[TD] DDBXD
[/TD]
[TD][/TD]
[TD]Mouting
[/TD]
[TD]

STD​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]14[/COLOR]​

[/TD]
[TD]

STD​

[/TD]
[TD]

5​

[/TD]
[TD] RSX1 LED P4 40K R4 MVOLT SPA DDBXD
[/TD]
[TD] DDBXD
[/TD]
[TD][/TD]
[TD]Quantity
[/TD]
[TD]

DWHXD​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]15[/COLOR]​

[/TD]
[TD]

STD​

[/TD]
[TD]

2​

[/TD]
[TD] RSX1 LED P3 50K R4 MVOLT SPA PE DDBXD
[/TD]
[TD] DDBXD
[/TD]
[TD][/TD]
[TD]Color
[/TD]
[TD]

10​

[/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]16[/COLOR]​

[/TD]
[TD]

STD​

[/TD]
[TD]

2​

[/TD]
[TD] RSX2 LED P3 30K R3 MVOLT SPA DDBXD
[/TD]
[TD] DDBXD
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]17[/COLOR]​

[/TD]
[TD]

STD​

[/TD]
[TD]

1​

[/TD]
[TD] RSX1 LED P2 40K R4 MVOLT SPA DDBXD
[/TD]
[TD] DDBXD
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]18[/COLOR]​

[/TD]
[TD]

STD​

[/TD]
[TD]

10​

[/TD]
[TD] RSX1 LED P3 40K R4 MVOLT RPA DDBXD
[/TD]
[TD] DDBXD
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]19[/COLOR]​

[/TD]
[TD]

MA​

[/TD]
[TD]

2​

[/TD]
[TD] RSX2 LED P4 50K R5 MVOLT MA DNATXD
[/TD]
[TD]DNATXD
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]20[/COLOR]​

[/TD]
[TD]

MA​

[/TD]
[TD]

8​

[/TD]
[TD] RSX2 LED P4 50K R3 MVOLT MA DNATXD
[/TD]
[TD]DNATXD
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]21[/COLOR]​

[/TD]
[TD]

STD​

[/TD]
[TD]

10​

[/TD]
[TD] RSX2 LED P4 40K R4 480 RPA DDBXD
[/TD]
[TD] DDBXD
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]22[/COLOR]​

[/TD]
[TD]

IS​

[/TD]
[TD]

1​

[/TD]
[TD] RSXF1 LED P4 50K WFL MVOLT IS PER7 DDBXD
[/TD]
[TD] DDBXD
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]23[/COLOR]​

[/TD]
[TD]

STD​

[/TD]
[TD]

4​

[/TD]
[TD] RSX1 LED P4 40K R5 MVOLT RPA DDBXD
[/TD]
[TD] DDBXD
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]24[/COLOR]​

[/TD]
[TD]

STD​

[/TD]
[TD]

8​

[/TD]
[TD] RSX1 LED P4 40K R5 MVOLT RPA DDBXD
[/TD]
[TD] DDBXD
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]25[/COLOR]​

[/TD]
[TD]

STD​

[/TD]
[TD]

2​

[/TD]
[TD] RSX1 LED P4 40K R5 MVOLT RPA DDBXD
[/TD]
[TD] DDBXD
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]26[/COLOR]​

[/TD]
[TD]

STD​

[/TD]
[TD]

1​

[/TD]
[TD] RSX1 LED P1 40K R3 MVOLT RPA DDBXD
[/TD]
[TD] DDBXD
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] "]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=E0E0F0]#E0E0F0[/URL] "]

[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]27[/COLOR]​

[/TD]
[TD]

STD​

[/TD]
[TD]

4​

[/TD]
[TD] RSX1 LED P4 50K R5 MVOLT SPA DDBXD
[/TD]
[TD] DDBXD
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid"]
<tbody>[TR]
[TD]Sheet: Sheet1
[/TD]
[/TR]
</tbody>[/TABLE]

what I've got in F:G is the table that I want to use as criteria and the list on the left is the one to filter based on it.

Could anyone guide me on this?

 

[RasGhul]

Hi Joe,

Can you use this? Copy the array formula across and down to suit total possible rows.

The Mounts & Colors are data validated into B1 & B3.

I'm not sure how to work your Qty criteria into the filter though;

Book1
	A	B	C	D	E	F
1	Mouting	STD			Mounting	Colors
2	Quantity	50			IS	DBLXD
3	Color	DDBXD			STD	DDBXD
4	Count Records	14			MA	DNAXD
5						DWHXD
6	Total Qty Req'd	65				DNATXD
7
8	Mounting	Qty Required	Description	Color
9	STD	9	RSX1 LED P1 40K R3 240 HS SPA NLTAIR2 PIRHN DDBXD	DDBXD
10	STD	5	RSX2 LED P2 40K R5 240 SPA NLTAIR2 PIRHN DDBXD	DDBXD
11	STD	2	RSX1 LED P1 40K R4 MVOLT HS SPA DDBXD	DDBXD
12	STD	5	RSX1 LED P4 40K R4 MVOLT SPA DDBXD	DDBXD
13	STD	2	RSX1 LED P3 50K R4 MVOLT SPA PE DDBXD	DDBXD
14	STD	2	RSX2 LED P3 30K R3 MVOLT SPA DDBXD	DDBXD
15	STD	1	RSX1 LED P2 40K R4 MVOLT SPA DDBXD	DDBXD
16	STD	10	RSX1 LED P3 40K R4 MVOLT RPA DDBXD	DDBXD
17	STD	10	RSX2 LED P4 40K R4 480 RPA DDBXD	DDBXD
18	STD	4	RSX1 LED P4 40K R5 MVOLT RPA DDBXD	DDBXD
19	STD	8	RSX1 LED P4 40K R5 MVOLT RPA DDBXD	DDBXD
20	STD	2	RSX1 LED P4 40K R5 MVOLT RPA DDBXD	DDBXD
21	STD	1	RSX1 LED P1 40K R3 MVOLT RPA DDBXD	DDBXD
22	STD	4	RSX1 LED P4 50K R5 MVOLT SPA DDBXD	DDBXD
Sheet2

Cell Formulas
Range	Formula
B4	=COUNTIFS(Sheet1!$A$2:$A$27,$B$1,Sheet1!$D$2:$D$27,$B$3)
B6	=SUMIF($A$9:$A$29,$B$1,$B$9:$B$29)
A9	{=IF(ROWS($A$9:A9)>$B$4,"",INDEX(Sheet1!A$2:A$27,SMALL(IF(Sheet1!$A$2:$A$27&Sheet1!$D$2:$D$27=$B$1&$B$3,ROW(Sheet1!$A$2:$A$27)-ROW(Sheet1!$A$2)+1),ROWS($A$9:A9))))}
Press CTRL+SHIFT+ENTER to enter array formulas.