Filtering two columns using Google Sheets

Question

I'm using a filter to update a column and it works. But now I need to create 2 filters inside the same cell.

Filter 1

=FILTER(ABD!C:C,ABD!K:K="Ok",ABD!J:J="Catarina Ferreira")

Filter 2

=FILTER(MM!E:E,MM!L:L="Ok",MM!K:K="Catarina Ferreira")

I need both filters to work inside the same cell. Is it possible?

player0 · Accepted Answer · 2020-03-24 23:44:56Z

1

try:

=IFNA(FILTER({ABD!C:C; MM!E:E}, {ABD!K:K; MM!L:L}="Ok", {ABD!J:J; MM!K:K}="Catarina Ferreira"))

answered Mar 24, 2020 at 23:44

131k14 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1