Copy Array Formula in 2013

  • Re: Copy Array Formula in 2013


    Hi Spomone,
    Welcome to the forum.


    You forgot to lock the cell references used in the formula. Try this....


    On Train Sheet,
    In D4

    Code
    1. =IFERROR(INDEX(Vol!C$4:C$2000,SMALL(IF(Vol!$B$4:$B$2000=$A$2,ROW(Vol!$C$4:$C$2000)-ROW(Vol!$C$4)+1),ROWS(C$4:C4))),"")


    Confirm with Ctrl+Shift+Enter and then copy across and down.

    Regards.
    sktneer