Filtering or looking up across multiple columns

Hi all, I am trying to filter or lookup across multiple columns. I have a “teams” table with people assigned to various team, and I want to show what teams people are assigned to in the “people” table.

See this example doc for what I am trying to do.

Searching the forum I found this approach, but people were not jazzed about it. Is there a better, more flexible way?

Screen Shot 2021-08-23 at 7.49.02 PM

Hi @Robin_Bigio :blush:

I have this formula

    [Product Lead],
    [Designer Lead],
    [Eng Team]).Contains(thisRow)

… which should gets you to the same results without the need to use OR :blush: .

Not sure if that’s much more flexible though as it would still require to modify the formula if or when you add more teams :blush:

Thanks @Pch, that helps :slight_smile:

No problem :grin: !

I’m glad to know it helps :grin: !