Adding OR for third array

[BittenApple]

Hello all,

This is the function:
IFERROR(INDEX(Sheet2!$A$2:$G$200,SMALL(IF((Sheet2!$A$2:$A$200=$A$2)*(Sheet2!$B$2:$B$200=$B$2),ROW(Sheet2!$A$2:$A$200)-MIN(ROW(Sheet2!$A$2:$A$200))+1),ROWS($A$5:$A7)),),"")


If I want to add:
Sheet2!$C$2:$C$200=Left($C$2,3)='pqc' OR Sheet2!$C$2:$C$200=Left($C$2,3)='ttt' OR Sheet2!$C$2:$C$200=Left($c$2)='ggg'
Then grab the columns

if not, then do this:
if Sheet2!$C$2:$C$200=Left($C$2,3)='TED' OR Sheet2!$C$2:$C$200=Left($C$2,3)='Shd' OR Sheet2!$C$2:$C$200=Left($c$2)='bbb'

Can I bring the result and then do OR on it?

Please let me know.
Regards,

[rory]

I don't understand the question - that looks like one simple OR with 6 options, not two separate tests.

[BittenApple]

I want to say if the first 2 letters is ab, cd, nm, kf then do this if not do other stuff. I wanted to add it to the function in the thread.

Regards,
Green

[HansV]

The way you ask your question makes it impossible to understand what you want. Slow down and try to explain as clearly as you can and in unambiguous detail, what you want the formula to do.