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

Hope this helps!

O'C Wrote:
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


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=319918