I'm using the following formula and now need to look for data matching CCYI
or CCYV. I've tried to use the OR but it returns a wrong answer.

{=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)),ROW('E373'!$T$1:$T$2000)))}

I'd pull the rest of my hair out if I had any!

Your help is greatly appreciated,
O'C