Forum Discussion
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 showing what I mean.
Basically, so far I have linked the checkbox to the cell next to the task (if it is ticked then that cell says true). I, therefore, need a formula that says "if the cell is true, then return the value of the cell to its left, in a list located at another location"
Hopefully, that is explanatory enough, but I will be happy to provide more information if needs.
Many thanks
Sam
- 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.- Thank you - that worked perfectly!!
