You use these functions when you want to find values based on the value in a corresponding cell. Thanks to the newish dynamic array function XLOOKUP(), you now have more power and less confusion.

There are a bunch of array functions and I'm wondering how to craft the query. For example, if I have an array column names text[] and I want to see if some set of names is in any rows, I might do: ...