jassybun
Member
I want to add another option to include besides "DAY" , like "NIGHT" and "EARLY" in the formula below, like this: (Conv!$L$1:$L$5000={"DAY", "NIGHT", "EARLY"}), but I cannot get it to work - I think this is because I have another multiple option in the same line: ={"1 - Over","2 - Under"}), How can I get around this?
=IF(ISERROR(INDEX(Conv!$A$1:$AX$5000,SMALL(IF((Conv!$L$1:$L$5000="DAY")*(Conv!$I$1:$I$5000>=$J$13)*(Conv!$H$1:$H$5000={"1 - Over","2 - Under"}), ROW(Conv!$D$1:$D$5000)-MIN(ROW(Conv!$D$1:$D$5000))+1,""),ROW(Conv!A1)),COLUMN(Conv!A1))),"", INDEX(Conv!$A$1:$AX$5000,SMALL(IF((Conv!$L$1:$L$5000="DAY")*(Conv!$I$1:$I$5000>=$J$13)*(Conv!$H$1:$H$5000={"1 - Over","2 - Under"}),ROW(Conv!$D$1:$D$5000)-MIN(ROW(Conv!$D$1:$D$5000))+1,""),ROW(Conv!A1)),COLUMN(Conv!A1)))
=IF(ISERROR(INDEX(Conv!$A$1:$AX$5000,SMALL(IF((Conv!$L$1:$L$5000="DAY")*(Conv!$I$1:$I$5000>=$J$13)*(Conv!$H$1:$H$5000={"1 - Over","2 - Under"}), ROW(Conv!$D$1:$D$5000)-MIN(ROW(Conv!$D$1:$D$5000))+1,""),ROW(Conv!A1)),COLUMN(Conv!A1))),"", INDEX(Conv!$A$1:$AX$5000,SMALL(IF((Conv!$L$1:$L$5000="DAY")*(Conv!$I$1:$I$5000>=$J$13)*(Conv!$H$1:$H$5000={"1 - Over","2 - Under"}),ROW(Conv!$D$1:$D$5000)-MIN(ROW(Conv!$D$1:$D$5000))+1,""),ROW(Conv!A1)),COLUMN(Conv!A1)))