I know how to look up one value in a list and return multiple corresponding values, but I don't know how to change the formula to two values.

My current code is:

=IF(ISERROR(INDEX($A$1:$K$21,SMALL(IF($K$1:$K$21="QUO",ROW($K$1:$K$21)),ROW(1:1)),5)),"",INDEX($A$1:$K$21,SMALL(IF($K$1:$K$21="QUO",ROW($K$1:$K$21)),ROW(1:1)),5))

I want it to also look up "Y" in column I; $I$1:$I$21="Y"

Thanks.

My current code is:

=IF(ISERROR(INDEX($A$1:$K$21,SMALL(IF($K$1:$K$21="QUO",ROW($K$1:$K$21)),ROW(1:1)),5)),"",INDEX($A$1:$K$21,SMALL(IF($K$1:$K$21="QUO",ROW($K$1:$K$21)),ROW(1:1)),5))

I want it to also look up "Y" in column I; $I$1:$I$21="Y"

Thanks.

## Comment