Hello,
I am using the row/index function to insert values from another sheet when certain criteria are met. Unfortunately, I’ve noticed that the formula seems to only shift cells down in that column whether then inserting an entire row for the value. Is it possible to adjust the formula below to make that happen? Thanks in advance!
{=IFERROR(INDEX(Input!$F$4:$F$<wbr>201,SMALL(IF(FREQUENCY(IF(1-(<wbr>Input!$F$4:$F$201=""),IF(<wbr>Input!$H$4:$H$201="Yes",IF(<wbr>Input!$A$4:$A$201=$A$4,MATCH(<wbr>Input!$F$4:$F$201,Input!$F$4:$<wbr>F$201,0)))),ROW(Input!$F$4:$F$<wbr>201)-ROW(Input!$F$4)+1),ROW(<wbr>Input!$F$4:$F$201)-ROW(Input!$<wbr>F$4)+1),ROWS($A$5:A5))),"")}
I am using the row/index function to insert values from another sheet when certain criteria are met. Unfortunately, I’ve noticed that the formula seems to only shift cells down in that column whether then inserting an entire row for the value. Is it possible to adjust the formula below to make that happen? Thanks in advance!
{=IFERROR(INDEX(Input!$F$4:$F$<wbr>201,SMALL(IF(FREQUENCY(IF(1-(<wbr>Input!$F$4:$F$201=""),IF(<wbr>Input!$H$4:$H$201="Yes",IF(<wbr>Input!$A$4:$A$201=$A$4,MATCH(<wbr>Input!$F$4:$F$201,Input!$F$4:$<wbr>F$201,0)))),ROW(Input!$F$4:$F$<wbr>201)-ROW(Input!$F$4)+1),ROW(<wbr>Input!$F$4:$F$201)-ROW(Input!$<wbr>F$4)+1),ROWS($A$5:A5))),"")}
