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

Please, post only in one newsgroup

http://www.cpearson.com/excel/newposte.htm

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Nothwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"EH003268" wrote in
message ...

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

I have a lot of columns (and rows)


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

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