excel how to achieve

bc 1 and 2, 3 I protect a how the column in other columns to achieve C = 1, so the number of column B in the same cell show ~ question added:What I want is ~ in the cell is displayed as:I, Paul

if the number of small and determined, can the formula = index (b:b, small (if (c1:c10 = 1, row (b1:b10)), 1 ))&”,”& index (b:b, small (if (c1:c10 = 1, row (b1:b10)), 2 ))&”,”& index (b:b, small (if (c1:c10 = 1, row (b1:b10)) , 3)) CTRL + SHHIFT + ENTER】 【set of known three or with VBA