Index/Match with Multiple Criteria

[LearnExcl]

Good morning, I was hoping I could get some assistance with adding another argument/criteria to the highlighted portion of the formula below:

=IFERROR(INDEX(INDEX('DATA'!$A$1:$AV$1000,,MATCH("Number",'DATA'!$A$1:$AV$1,0)),MATCH(0,<wbr style="font-family: arial, sans-serif; font-size: 12.8px;">IF(INDEX('DATA'!$A$1:$AV$1000,,MATCH("Current",'DATA'!$A$1:$AV$1,0))=1,IF(<wbr style="font-family: arial, sans-serif; font-size: 12.8px;">INDEX('DATA'!$A$1:$AV$1000,,MATCH("CODE",'DATA'!$A$1:$AV$1,0))="0003",<wbr style="font-family: arial, sans-serif; font-size: 12.8px;">COUNTIF($A$1:A1,INDEX('DATA'!$A$1:$AV$1000,,MATCH("Number",'DATA'!$A$1:$AV$1,0))))),0)),"")

What I would like to do is to also include the data where the code not only matches "0003", but also "1004."

Any and all help will be appreciated.

 

[bsquad]

I am not sure the exact columns your trying to index, because I don't know what "Number" or "Current" etc which columns they are in so I just have this formula pretty generic,

this also needs to be set as an array, but go nuts

=IFERROR(IF(ROWS($A$1:A1)>SUMPRODUCT(--($A$2:$A$1000=1),--($B$2:$B$1000="0003"),--($C$2:$C$1000="1004")),"",IFERROR(INDEX($D$2:$D$1000,MATCH("1"&"0003"&"1004",$A$2:$A$1000&$B$2:$B$1000&$C$2:$C$1000,0)),"")),"")

 

[LearnExcl]

Is it possible to revise the original formula to include the argument I was mentioning? I would like to know whether it is possible, as I tried multiple ways with no luck.

 

[bsquad]

is the one I posted not what you were looking for?

The one you have, I am sure its possible as with formulas, visual basic there are 1k ways to do one thing - try using COUNTIFS instead of COUNTIF in your formula. I'll go to the extent of what I had posted, but with what you have; is more complicated then it has to be.

 

[bsquad]

Sorry I didn't realize you had a multi column INDEX. Use the addin located at the hyperlink, post your data or at least test data so I can see your column and row setup

https://www.mrexcel.com/forum/about-board/857232-forum-tools-add-using-installing.html