Is it possible to FILTER using a range/list?
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