Create a list using a lookup with ifs

[hmiller]

	A	B	C
1	Harry Potter	Y	1
2	Hermione Granger		2
3	Ron Weasley	Y	0
4	Draco Malfoy	Y	-1
5	Neville Longbottom		1
6	Luna Lovegood	Y	-2
7	Ginny Weasley	Y	-1

<tbody>
</tbody>

I want to be able to return a list of people if column B and C match the conditions I specify. So for example, I want it so that if column B = "Y" and column C is <0 then it returns all values in column A that match that criteria, along with the value from column C. So in the above example if column B is Y and C is <0 it would give me

Draco Malfoy	-1
Luna Lovegood	-2
Ginny Weasley	-1

<tbody>
</tbody>

Anyone able to help please?

 

[hmiller]

I suspect it's not a lookup I need as I'm looking up more than one thing. It might be INDEX but that's not a function I've used before so wouldn't know where to start.

 

[hmiller]

If someone can do it so it only returns a list of names without the minus numbers then that's a start at least. I would ideally like the numbers though.

 

[hmiller]

Still haven't worked out how to do this. A pivot table won't work as it is going to be used as a template across several departments in school.