combine an if and or forumla for text values

Hi,

I have a column say column A that holds text. If the values match say:

ABC1 or
ABC2 or
ABC3

And also match column B if it shows "Yes" then show "Correct" or "Not Correct" as appropriate.

Please can someone advise?

Thank you in advance

A (very) slight variant on Stormseed's formula:

=IF(AND(OR(A1={"ABC1","ABC2","ABC3"}),B1="yes"),"Correct","Not Correct")

I don't have the knowledge to answer that Stormseed though I suspect the memory issues associated with an inline array constant are not the same as those associated with array formulae.