0
I need to show only the domains that a particular account is part of.
I tried a few ways with TEXTJOIN, IF, INDEX, and the most I got was the result below, that it ends up showing the whole array as a result instead of just the domains that this account exists.
On the other hand, the line searching for the user Operator shows nothing as a result:
.
Does anyone know how I get this result?
=TEXTJOIN(";"; TRUE; IF(A2:A10=$E$2; B2:B10; ""))
I did not understand what is the expected result, could edit with what you want the formula to accomplish?
– danieltakeshi
If the admin has more than one domain it will appear where? In column C? In cell B3 and move the rest down?
– Evilmaax