I am attempting to pull the categories that names are found in, and have it working all but for blank/missing names.
=TEXTJOIN(", ",TRUE,UNIQUE(IF(ISNUMBER(SEARCH(A1,'Master'!C:C)),LEFT('Master'!A:A,4),"")))
The cell "A1" is blank, and I am trying to pull the results (first 4 left characters...