Adding Another Criteria

[MARKEGANDERSON]

Hello guys- I am trying to add another criteria to the below:

=IF(ROWS($A$3:A3)>$A$2,"",INDEX(Data!$A$2:$A$110,SMALL(IF(Data!M$2:M$110=Data!$Q$6,IF(Data!C$2:C$110=Data!$Q$8,ROW(Data!$A$2:$A$110)-ROW(Data!$A$2)+1)),ROWS($A$3:A3))))

Would like to add this portion:

IF(Data!M$2:M$110=Data!$Q$11

I tried adding the IF(or but did not work

=IF(ROWS($A$3:A3)>$A$2,"",INDEX(Data!$A$2:$A$110,SMALL(IF(OR(Data!M$2:M$110=Data!$Q$6,Data!M$2:M$110=Data!$Q$11),IF(Data!C$2:C$110=Data!$Q$8,ROW(Data!$A$2:$A$110)-ROW(Data!$A$2)+1)),ROWS($A$3:A3))))

 

[Fluff]

How about
=IF(ROWS($A$3:A3)>$A$2,"",INDEX(Data!$A$2:$A$110,SMALL(IF((Data!M$2:M$110=Data!$Q$6)+(Data!M$2:M$110=Data!$Q$11),IF(Data!C$2:C$110=Data!$Q$8,ROW( Data!$A$2:$A$110)-ROW(Data!$A$2)+1)),ROWS($A$3:A3))))

 

[MARKEGANDERSON]

Thanks Fluff- It worked!!!

 

[Fluff]

You're welcome & thanks for the feedback