Forum Discussion
TextJoin Partial Matches?
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 whi...
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 !!
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],""))
- Great, that works too. thanks for refining !!
No problem!
Works perfect! Thanks so much guys. Was scratching my head on that one.
