TextJoin Partial Matches?

Highlighted
New Contributor

Hello, 

 

I have a list of usernames that have access to one or more location codes separated by commas. I also have a list of locations with their code on another tab. I have been trying every which way to cross reference the location code by the locations that each username has access to return a TextJoin of which usernames have access to that specific location. Any suggestions?

 

image.pngimage.png 

 

 

6 Replies
Highlighted

@meklund ,

Please find a possible solution using following formula in the attached file. 

=TEXTJOIN(",",TRUE,IF( IFERROR(FIND(TRIM([@Code]),User_access[Website access]),)>0,User_access[Username],""))

 

Please note that the data has been formatted as two tables - User_access and Location_access. 

 

Hope it works for you !!

 

Highlighted

@Kodipady 

 

You may tweak your formula like this as IFERROR and >0 are not required here and can be replaced with ISNUMBER.

 

=TEXTJOIN(",",TRUE,IF(ISNUMBER(FIND(TRIM([@Code]),User_access[Website access])),User_access[Username],""))

Highlighted
Great, that works too. thanks for refining !!
Highlighted

@Kodipady 

No problem!

Highlighted

@Subodh_Tiwari_sktneer 

@Kodipady 

 

Works perfect! Thanks so much guys. Was scratching my head on that one. 

Highlighted

@meklund 

You're welcome! Glad we could help.