Retrieve data and create a list based on multiple criterias

[Jarke]

Hi all,

I'm trying to create a formula in which I can pull names from my big data table. One formula and I can drag it down and it fills up with all approved names (based on the criterias).

I have names in column A, values in column B and other values in column C.

I want to retrieve all names which has a value bigger than zero in column B and who also have a value bigger than 10 in column C.

How should I go about it? No expert at Index or Match yet, and have given to much energy on trying to figuring it out by myself now


Thanks alot in advance!

 

[MARZIOTULLIO]

	A​	B​	C​	D​	E​
1​	name	value	value		name
2​	a	5​	15​		a
3​	b	3​	22​		b
4​	c	0​	11​
5​	d	4​	9​

<tbody>
</tbody>

e2=IFERROR(INDEX($A$2:$A$5,SMALL(IF($B$2:$B$5>0,IF($C$2:$C$5>10,ROW($A$2:$A$5)-ROW($A$2)+1)),ROWS($A$2:A2))),"")

control+shift+enter copy down

 

[Jarke]

Thank you alot mate! Works like a charm.

Keep up the great work

 

[MARZIOTULLIO]

you are welcome