This is a screen clip of 2 sheets in Excel 2013. What I am trying to do is that if the checkbox corresponding with the row is checked, the text in the row shows up in the second sheet. There will be around 75 rows of text with checkboxes. Some number of these will be checked, and for each one checked, the text should show up on the second sheet (with the displayed rows contiguous; all of the text cells for the row copied but not the checkbox).
I have gotten as far as inserting the checkbox, assigning it to a column to show true/false that I will hide later, and trying to use a VLOOKUP. The problem is it just outputs the first value checked. What I need help with is making this work for multiple checkboxes. When I input it with multiple IF functions, it only shows the output for the first checked box and nothing past it.
I have tried formulas such as:
=VLOOKUP(TRUE,TEKS!$A$2:$K$77,4) or
=IF(VLOOKUP(TRUE,TEKS!$A$2:$K$77,4)=A1,VLOOKUP(TRUE,OFFSET(TEKS!$A$2:$K$77, 1, 0),4))
These I know do not work, but they are my best attempts. I figure that if I am able to get the cells from column D of the first sheet, I can get the other columns with an if statement.