Nth instance, multiple criteria

team score TC.xlsm - Excel-000582.jpg

im looking to find the Nth instance based on 2 criteria. so in the attached image, if i wanted the reason for the second instance of dana that has an x in the "Include" column, i should get the result "FILLER". what formula would i use for this?

Hi,
maybe something like that:

=INDEX($C$1:$C$10,AGGREGATE(15,6,ROW($A$1:$A$10)/(ISNUMBER(SEARCH("DANA",$B$1:$B$10)*(A1:A10="X"))),2))

HEY! i think that is what im looking for. not the way i was trying at all. thank you!

I corrected my solution, this would be more accurate and cover all cases:

=INDEX($C$1:$C$10,AGGREGATE(15,6,ROW($A$1:$A$10)/(((ISNUMBER(SEARCH("DANA",$B$1:$B$10))*($A$1:$A$10="X")))),2))

(the former counted also cases that didnt have "x" in A) .

HA, YOUR AWESOME. i came back to this thread to tell you that when i started to work this into my sheet, it was still pulling the instance without an X although seems you caught it before me. Thanks again!

HAHA you're welcome. sorry for not catching this sooner, the place of the parentheses is significant and makes the whole difference!