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 ...
Hi
In I4 and copy down:
=IFERROR(INDEX(D:D,AGGREGATE(15,6,ROW($E$4:$E$37)/$E$4:$E$37,ROWS(I$4:I4))),"")
Hi
In I4 and copy down:
=IFERROR(INDEX(D:D,AGGREGATE(15,6,ROW($E$4:$E$37)/$E$4:$E$37,ROWS(I$4:I4))),"")