if formula..please help...

[pedie]

=IF(C4=G13,"Yes","No") is working fine

but when i use

=IF(C4=G13:G25,"Yes","No") it does not work.

What i'm actually trying to do here is that...if C4 value which is date is = any value in range G13:G25 then Y, N.

but when i select the range it is not working. please help.

THank you

 

[dado6612]

Maybe..

=IF(COUNTIF(G13:G25,C4)=0,"No","Yes")

 

[mgirvin]

Try this formula:

=IF(OR(B12=G13:G25),"Yes","No")

This is an array formula so use Ctrl + Shift + Enter, instead of just Enter.

 

[pedie]

Great, thank you so much!