you shouldn't use row(6:25). It is used to establish an offset into the
index range - so you should keep it as Row(1:19)

--
Regards,
Tom Ogilvy


"amyacc " wrote in message
...
=INDEX('[Development
Update.xls]MASTER'!$I$6:$I$25,SMALL(IF(('[Development
Update.xls]MASTER'!$A$6:$A$25="X")*('[Development
Update.xls]MASTER'!$G$6:$G$25="Y"),ROW(6:25)),1))

Here's the formula. Again, the answer it's pulling does not only not
contain "Y", that cell in that row is blank. It's not the only cell in
that column that is blank. There really seems to be no reasoning
behind this.

THANKS!


---
Message posted from http://www.ExcelForum.com/

Hi there.

Your info worked but can you explain why it worked?

Thanks.

-Am

--
Message posted from http://www.ExcelForum.com

Hi
Tom used the ROW(1:300) as parameter for the SMALL function (cycling
from 1 to 300). So getting the following values:
SMALL(....,1)
SMALL(....,2)
....
SMALL(....,300)

if you change this you don't start with the smalles but in your case
with the 6th smallest

--
Regards
Frank Kabel
Frankfurt, Germany
"amyacc " schrieb im
Newsbeitrag ...
Hi there.

Your info worked but can you explain why it worked?

Thanks.

-Amy


---
Message posted from http://www.ExcelForum.com/