Aug 22 2019 03:48 PM
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?
Aug 23 2019 01:17 AM
@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 !!
Aug 23 2019 03:42 AM
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],""))
Aug 23 2019 08:46 AM
Works perfect! Thanks so much guys. Was scratching my head on that one.