Formula: IF(OR( in a range of cells - true if one value

[hamistasty]

In the following formula:

=IF(OR(Schedule!A:A="FIC001",Schedule!A:A="FIC002"),"Y","N")

I want the true statement to be true if any of the OR statements are in ANY of the cells in column A.

So far it returns a false statement when there is at least one "FIC001" value in column A.

tia

 

[Jon von der Heyden]

Try;

=IF(SUM(SUMIF(Schedule!A:A,{"FIC001";"FIC002"})),"Y","N")

 

[hamistasty]

That didn't work. It still comes up as N when FIC001 and FIC002 are both in seperate cells in column A.

 

[T. Valko]

That didn't work. It still comes up as N when FIC001 and FIC002 are both in seperate cells in column A.

Try this...

=IF(SUM(COUNTIF(Schedule!A:A,{"FIC001";"FIC002"})),"Y","N")

 

[hamistasty]

Thanks you're amazing

 

[T. Valko]

Thanks you're amazing

You're welcome!

 

[Jon von der Heyden]

bah