Does anyone know how i can change this formula so that i can just drag
it down. I have
=IF(ISERROR(INDEX(Sheet2!$A$1:$X$569,SMALL(IF(Shee t2!$A$1:$A$569=$B$1,ROW(Sheet2!$A$1:$X$569)),ROW(1 :1)),ROW(15:15),1)),"
",INDEX(Sheet2!$A$1:$X$569,SMALL(IF(Sheet2!$A$1:$A $569=$B$1,ROW(Sheet2!$A$1:$X$569)),ROW(1:1)),ROW(1 5:15),1))
And when i drag down i want
=IF(ISERROR(INDEX(Sheet2!$A$1:$X$569,SMALL(IF(Shee t2!$A$1:$A$569=$B$1,ROW(Sheet2!$A$1:$X$569)),ROW(2 :2)),ROW(15:15),1)),"
",INDEX(Sheet2!$A$1:$X$569,SMALL(IF(Sheet2!$A$1:$A $569=$B$1,ROW(Sheet2!$A$1:$X$569)),ROW(2:2)),ROW(1 5:15),1))

I want the Red (15:15) to remain unchanged.
Thanks


--
EH003268
------------------------------------------------------------------------
EH003268's Profile: http://www.excelforum.com/member.php...o&userid=11806
View this thread: http://www.excelforum.com/showthread...hreadid=532879