Index Small using Or

Hi

I'm looking to build a list of customers ( Col N) looking for the value C3 and then also either 'not' paid' or 'payment not found' in Col AA

This is what I thought would work but it just gives me the first value in the table

INDEX(dgts_current!$A$3:$N$10000,SMALL(IF(OR((dgts_current!$N$3:$N$10000=$C$3)*(dgts_current!$AA$3:$AA$10000="not paid"),(dgts_current!$N$3:$N$10000=$C$3)*(dgts_current!$AA$3:$AA$10000="payment not found")),ROW(dgts_current!$N$3:$N$10000)),ROW(1:1))-2,1)

Any ideas - I think I'm close?

Try

=INDEX(dgts_current!$A$3:$N$10000,SMALL(IF((((dgts_current!$AA$3:$AA$10000="payment not found")+(dgts_current!$AA$3:$AA$10000="not paid"))*(dgts_current!$N$3:$N$10000=$C$3),ROW(dgts_current!$N$3:$N$10000)),ROW(1:1))-2,1)

not quite
INDEX(dgts_current!$A$3:$N$10000, AGGREGATE(15,6, ROW(dgts_current!$N$3:$N$10000)/(dgts_current!$N$3:$N$10000=$C$3)/ISNUMBER(SERCH(“not “,dgts_current!$AA$3:$AA$10000)), ROW(1:1))-2,1)
not array formula

Thanks - this gives me a #Name? result (I changed SERCH to SEARCH)?

Hi - thanks but this gives me a "...contains an error" message

No error with this version of Tim's formula ..

=IFERROR(INDEX(dgts_Current!$A$3:$N$10000, AGGREGATE(15,6, ROW(dgts_Current!$N$3:$N$10000)/(dgts_Current!$N$3:$N$10000=$C$3)/ISNUMBER(SEARCH(“not “,dgts_Current!$AA$3:$AA$10000)), ROW(1:1))-2,1),"")

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thanks Ali - the reply was to Tim who offered the option with SERCH in it - I corrected that to SEARCH but still got the 'name' error - will keep trying with this.

Many thanks Shukla - this seems to do the trick!