INDEX array formula returning same value

Hi All,

I know I can do this as I have already succeeded once but since moving a few things on my spread sheet the formula has gone wrong and I can't correct it.

I have one sheet with many different lines on and another I would like to select certain rows with the same reference number in column A. Below is the formula I am using

=IF(ISERROR(INDEX(Lines!$A$2:$J$200,SMALL(IF(Quote!$AL$4=Lines!$A$2:$A$200,ROW(Lines!$A$2:$A$200)-MIN(ROW(Lines!$A$2:$A$200))+1,""),ROW(Lines!$A$2:$A$200)),COLUMN(C1))),"",INDEX(Lines!$A$2:$J$200,SMALL(IF(Quote!$AL$4=Lines!$A$2:$A$200,ROW(Lines!$A$2:$A$200)-MIN(ROW(Lines!$A$2:$A$200))+1,""),ROW(Lines!$A$2:$A$200)),COLUMN(C1)))

Can anyone spot what my error is as it is returning the same value for me each time.

Thanks, Katie

You probably need to upload a workbook with an example of what your data looks like but as a guess, change:
column(C1)
to
row(C1)

Please see the attached list. I need the lines sheet transferring to the quote sheet. Hope it makes sense.Example.xlsm

That's perfect, it works again. Would it be possible for you to briefly explain what I had done wrong?