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 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?
6 Replies
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 !!
