Forum Discussion
Solved
Combining IF and INDEX functions
In a nutshell, I am trying to create a form that has a list of tasks in it. If the users tick the checkbox next to task 1 etc. it will then appear in a separate list. I have attached a workbook ...
- This array formula entered into cells I4:I37 seems to do the trick:
=IFERROR(INDEX($D$1:$D$37,SMALL(IF($E$4:$E$37,ROW($E$4:$E$37),""),ROW($D$1:$D$34))),"")
Mind you, if the user changes checkboxes after entering explanations into column J, the comments no longer align with the checked boxes.
This array formula entered into cells I4:I37 seems to do the trick:
=IFERROR(INDEX($D$1:$D$37,SMALL(IF($E$4:$E$37,ROW($E$4:$E$37),""),ROW($D$1:$D$34))),"")
Mind you, if the user changes checkboxes after entering explanations into column J, the comments no longer align with the checked boxes.
=IFERROR(INDEX($D$1:$D$37,SMALL(IF($E$4:$E$37,ROW($E$4:$E$37),""),ROW($D$1:$D$34))),"")
Mind you, if the user changes checkboxes after entering explanations into column J, the comments no longer align with the checked boxes.
Thank you - that worked perfectly!!