SMALL and IF and OR functions not working together

[jassybun]

I added an "OR" FUNCTION and now the formula no longer works correctly. It instead brings up every value, almost like its not even there, instead of filtering the only two I need. Any help is greatly appreciated!

=IF(ISERROR(INDEX(TAW!$A$2:$L$988,SMALL(IF(OR(TAW!$B$2:$B$988="10-INTL TRADE SERVICES",TAW!$B$2:$B$988="15-SERVICES US"), ROW(TAW!$D$2:$D$988)-MIN(ROW(TAW!$D$2:$D$988))+1,""),ROW(TAW!D1)),COLUMN(TAW!D1))),"", INDEX(TAW!$A$2:$L$988,SMALL(IF(OR(TAW!$B$2:$B$988="10-INTL TRADE SERVICES",TAW!$B$2:$B$988="15-SERVICES US"), ROW(TAW!$D$2:$D$988)-MIN(ROW(TAW!$D$2:$D$988))+1,""),ROW(TAW!D1)),COLUMN(TAW!D1)))

It worked before when it was like this (without the OR function and missing the 2nd option):

=IF(ISERROR(INDEX(TAW!$A$2:$L$988,SMALL(IF(TAW!$B$2:$B$988="15-SERVICES US", ROW(TAW!$D$2:$D$988)-MIN(ROW(TAW!$D$2:$D$988))+1,""),ROW(TAW!D1)),COLUMN(TAW!D1))),"", INDEX(TAW!$A$2:$L$988,SMALL(IF(TAW!$B$2:$B$988="15-SERVICES US", ROW(TAW!$D$2:$D$988)-MIN(ROW(TAW!$D$2:$D$988))+1,""),ROW(TAW!D1)),COLUMN(TAW!D1)))

 

[NARAYANK991]

Hi ,

See if this works :

=IF(ISERROR(INDEX(TAW!$A$2:$L$988,SMALL(IF(TAW!$B$2:$B$988={"15-SERVICES US","10-INTL TRADE SERVICES"},ROW(TAW!$B$2:$B$988)-MIN(ROW(TAW!$B$2:$B$988))+1),ROWS($A$1:$A1)),COLUMN(TAW!D1))),"",INDEX(TAW!$A$2:$L$988,SMALL(IF(TAW!$B$2:$B$988={"15-SERVICES US","10-INTL TRADE SERVICES"},ROW(TAW!$B$2:$B$988)-MIN(ROW(TAW!$B$2:$B$988))+1),ROWS($A$1:$A1)),COLUMN(TAW!D1)))

Enter it as an array formula , using CTRL SHIFT ENTER.

Narayan

 

[jassybun]

You are amazing - worked perfectly - ty!