On Google Sheets, copy the contents of a column to another column but skip some destination cells-CodePudding

On a Google sheets, column A has checkboxes, column C is a list of items.

Copy all the items from column C to column B but skip the destination cells that are on the same row as a checked box from column A.

No cells from column C should be skipped.

Here's the sheet with the desired result in column B:

CodePudding user response：

Another approach (tick boxes in A1:A, source list in B1:Bn):

=arrayformula(ifna(vlookup(query(reduce(,A1:index(A:A,counta(B:B) countif(A:A,true)),lambda(a,r,{a;if(r=true,,max(a) 1)})),"offset 1",0),{row(B:B),B:B},2,0)))