EH003268 Wrote:
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
Row(15:15) = 15,
If you dont want it change while dragging why don't you just edit it as
15.
OverAC


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