Extract List from table with 2 variables

[ManUBlueJay]

In the below table I would like to be able to get a list of items from List 1 That meets 2 criteria's. D1 gives me a choice of entry I am making, in this case fruit.
In Col E I would like to show a list of all items in List 1 that are equal to D1 and have a qty greater than 0 listed in C1:C8

	A	B	C	D	E
1	List 1	Type	Qty	Fruit	List 2
2	Apples	Fruit			Oranges
3	Oranges	Fruit	10		Bananas
4	Bananas	Fruit	10
5	Pears	Fruit
6	Almonds	Nuts
7	Pecans	Nuts
8	Brazil	Nuts

 

[Fluff]

How about, in E2 filled down
=IFERROR(INDEX($A$2:$A$8,AGGREGATE(15,6,(ROW($A$2:$A$8)-ROW($A$2)+1)/(($B$2:$B$8=$D$1)*($C$2:$C$8>0)),ROWS(E$2:E2))),"")

 

[ManUBlueJay]

Too Easy.
Thanks a bunch

 

[DanteAmor]

Try this array formula, in E2 and copy down

{=IFERROR(INDEX($A$2:$A$8, SMALL(IF(($B$2:$B$8=$D$1)*($C$2:$C$8>0), ROW($C$2:$C$8)), ROWS($D$2:D2))-1),"")}

Array formulas
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself.

 

[Fluff]

You're welcome & thanks for the feedback