Thread: Excel Array Question
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
amyacc[_3_] amyacc[_3_] is offline
external usenet poster
  
Posts: 1
Default Excel Array Question
=INDEX('[Developmen
Update.xls]MASTER'!$I$6:$I$25,SMALL(IF(('[Developmen
Update.xls]MASTER'!$A$6:$A$25="X")*('[Developmen
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 no
contain "Y", that cell in that row is blank. It's not the only cell i
that column that is blank. There really seems to be no reasonin
behind this.

THANKS

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

Reply With QuoteReply With Quote