Check if an array contains a value

Have a basic problem, but coulnd’t find a basic response.
I’ve put all my google sheet values into an array.

I just want to make a basic filter to check if a value in contained in the array, but couldn’t find how to do this.
I tried to use map + contains function (see picture), but nothing seems to work.
Any idea? Thanks !


You should be using an ARRAY operator, not a TEXT operator.

Hope this helps! Let me know if there are any further questions or issues.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

1 Like

Thanks, it was too obvious for me :slight_smile:

1 Like