Try this...

{=INDEX('E373'!$T$1:$T$2000,SMALL(IF(('E373'!$Y$1: $Y$2000='STATUS
SHEET'!B3)*('E373'!$Q$1:$Q$2000="CCYI"),ROW('E373' !$T$1:$T$2000),IF(('E373'!$Y$1:
$Y$2000='STATUS
SHEET'!B3)*('E373'!$Q$1:$Q$2000="CCYV"),ROW('E373' !$T$1:$T$2000))),ROW('E373'!$T$1:$T$2000)))}

It is not as nice as an OR statement, but it should receive the same
result.


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=319918