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/