Issue with LARGE, MATCH, INDEX and duplicates, multiple conditions

Hey all: having a pretty common problem with using LARGE to find the 6 biggest recent transactions in raw data from a bank feed; trying to match transaction descriptions but INDEX MATCH and VLOOKUP all just take the top result.

I made progress with the solution posted in this forum thread...

http://www.excelforum.com/excel-form...uplicates.html

...and managed to get the first half of the initial IF formula to register "FALSE."

=IF(COUNTIF(M$27:M32,M32)=1,INDEX(mint!C:C,MATCH(LARGE(IF(mint!E:E="debit",IF(mint!G:G="Walnut-XXX4",mint!D:D)),6),mint!D:D,0)))

However, my original formula contains 2 nested IFs:

=INDEX(mint!C:C,MATCH(LARGE(IF(mint!E:E="debit",IF(mint!G:G="Walnut-XXX4",mint!D:D)),5),mint!D:D,0))

...and I am struggling to figure out how to plug those conditions into the 2nd half of the initial IF formula as posted on the linked thread above:

INDEX($A$50:$A$65,SMALL(IF($B$50:$B$65=B4,ROW($B$50:$B$65)-ROW($B$49),""),COUNTIF(B$3:B4,B4))))

Any and all help greatly appreciated!

Thanks FDibbins! After another hour of banging my head against the screen I think I solved this. I'm sure I'll have another question soon and will use a dummy workbook at that time.

Thanks!

Sure!

=IF(COUNTIF(mint!D:D,M27)=1,INDEX(mint!C:C,MATCH(LARGE(IF(mint!E:E="debit",IF(mint!G:G="Walnut-XXX4",mint!D:D)),1),mint!D:D,0)),INDEX(mint!C:C,SMALL(IF(mint!D:D=M27,ROW(mint!D:D),""),COUNTIF(mint!D:D,M27))))

Turns out I didn't need to include the nested IFs in the 2nd half of the equation (which is giving the FALSE value for the initial IF formula). As explained by JosephP in the linked thread above (http://www.excelforum.com/excel-form...uplicates.html), the FALSE equation:

INDEX(mint!C:C,SMALL(IF(mint!D:D=M27,ROW(mint!D:D),""),COUNTIF(mint!D:D,M27))))

...seems to work just fine. If it bugs out I may return!