r/googlesheets•
Spacebar0

Is it possible to FILTER using a range/list?

Solved

Right now I have a formula that looks like this:

=FILTER($C$3:$C,(AH3:AH="Freedom")+(AH3:AH="Prosperity")+(AH3:AH="Transience")+(AH3:AH="Admonition"))

It's not ideal because I'll eventually keep adding more items to this list and I'd like to be able to just reference a range instead, kinda like this:

=FILTER($C$3:$C,AH3:AH=X1:X4)

But this only returns one matching item, so is it possible?

Posted Mar 6, 2023, 1:54 PM UTC

83
Loading comments…