title: How do you align column values and keep the association of all columns to the right of column C with column C?
body: <p>I am using =IF(ISNA(MATCH(A1,C:C,0)),"",INDEX(C:C,MATCH(A1,C:C,0))) to align column values, but I would like to keep the association of all columns to the right of column C with column C.</p>