Forum Discussion

Sam Collins's avatar
Sam Collins
Copper Contributor
Oct 03, 2018

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

excel
Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Oct 03, 2018

    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))),"")
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Oct 03, 2018

    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))),"")

Resources