# Listing cell values from table with certain results

#### Tequilashot

##### New Member
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.

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

#### Weazel

##### Well-known Member
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

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

Replies
0
Views
353
Replies
3
Views
395
Replies
6
Views
361
Replies
4
Views
781
Replies
0
Views
233

1,191,173
Messages
5,985,097
Members
439,940
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back