Solved: Multiple value lookup - Page 2

Colin_Lough · 01-14-2021 06:37 AM

Hi,

I have an expression where based on the logged in user’s team name, a slice will return a subset of data from my main table. I went with an assumption that 1 user has 1 team, but now have a use case where a user wants to see multiple team allocations. Can anyone suggest an edit to the formula below, please?

I’m looking to return the rows where the user could have 2 x “Team Name” listed in the Users table, i.e., Team A , Team B

AND([Portfolio Status]= “Active” ,
[team name] = LOOKUP( USEREMAIL() , “Users” , “Useremail” , “Team Name” ))

Suvrutt_Gurjar

Oh , I am sorry, my bad of an in advertently inserted incorrect operator in the expression

Please try
AND([Portfolio Status]= “Active” ,
IN([Team Name], SELECT(Users [Team Name] , [Useremail] =USEREMAIL())))

View solution in original post