Listing cell values from table with certain results

[Tequilashot]

Sorry I had no idea what title to give this post, so may sound confusing.

Supplier1	100	Paid
Supplier 2	150	Overdue
Supplier 3	125	Paid
Supplier 4	130	Paid
Supplier 5	140	Paid
Supplier 6	200	Overdue
Supplier 7	200	Paid
Supplier 8	150	Paid

<tbody>
</tbody>

What I need is some sort of index match formula to be able to ignore any row with "Paid" in it, I would like something that returns the value of cells A2 and A6 (as they are overdue) and be able to list them in a separate table. I understand a quick filter with a copy and paste can do this but I was wondering is there such a formula that will populate a new table for me automatically?

My results would look something like this;

Supplier 2	150
Supplier 6	200

<tbody>
</tbody>

It's probably something simple but it's the end of the day and my brain is melted, any help would be appreciated.

 

[Weazel]

something like...

E2=IFERROR(INDEX(A$2:A$9,SMALL(IF($C$2:$C$9="Overdue",ROW(A$2:A$9)-ROW(A$2)+1),ROWS(E$2:E2))),"") control shift enter

Row\Col	A​	B​	C​	D​	E​	F​
2​	Supplier1	100​	Paid		Supplier 2	150​
3​	Supplier 2	150​	Overdue		Supplier 6	200​
4​	Supplier 3	125​	Paid
5​	Supplier 4	130​	Paid
6​	Supplier 5	140​	Paid
7​	Supplier 6	200​	Overdue
8​	Supplier 7	200​	Paid
9​	Supplier 8	150​	Paid

<tbody>
</tbody>

 

[Tequilashot]

Oh wow that's brilliant thank you! Worked a charm.