INDEX(MATCH based on two criteria

[mattc_uk]

I need to use an INDEX(MATCH formula based on two criteria. The attached spreadsheet works using 1 criteria, I just need to now base it on 2.

Please Login or Register  to view this content.

See attached for better explanation. Any help would be greatly appreciated

[JohnTopley]

try

=IFERROR(INDEX('All Transactions'!$B$2:$B$10,MATCH(1,INDEX(('All Transactions'!$A$2:$A$10=$B$5)*('All Transactions'!$D$2:$D$10=$C$4)*(COUNTIF(C$9:C9,'All Transactions'!$B$2:$B$10)=0),),0)),"")

[Estevaoba]

Another option:

Array enter (ctrl+shift+enter) this and copy across and down.

=IFERROR(INDEX('All Transactions'!$B$2:$B$10,SMALL(IF('All Transactions'!$A$2:$A$10=$B$5,IF('All Transactions'!$D$2:$D$10=C$4,ROW('All Transactions'!$A$2:$A$10)-1)),ROW($N1))),"")