OR function

**ryan77705** · 01-30-2013, 04:23 AM

Is there a way to use the OR function with a range of cells such as a1-a1000 so that if any of the a1-a1000=c1(cell with set value) b1 would change to yes. I have tried a lot of formulas but they all will only work with the cell value in the same row so if I put a3=c1 I still get b1=false but if I get a1=c1 I get b1=true. I would like that if any of the cells whether its a1 or a598 to change b1 to yes if the value in c1 is entered. Please help

**abubaniyan** · 01-30-2013, 04:34 AM

why dont you use countifs....!

regards
abdul

**ryan77705** · 01-30-2013, 04:40 AM

OMG!! Ty so much lol. To think I spent that much time on it and that just took me 5 seconds.

**ryan77705** · 01-30-2013, 05:01 AM

Ok for the second part of the question. when I click and drag the formula =IF(countif(a1:a1000,C1),"yes","no") I need c1 to change to c2 like it does but I need a1:a1000 to stay the same. Is there any way to do that?

**Pepe Le Mokko** · 01-30-2013, 04:36 AM

Try

=IF(countif(a1:a1000,C1),"yes","no")

**dilipandey** · 01-30-2013, 04:40 AM

Hi ryan77705

Welcome to the forum.
Range A1:A1000 can be checked for a value using Match function with syntax as =match(<value to match>, < range in which match is to be checked>,0) and you can use this function in B1 as =if(isnumber(match( < above formula>)),"Yes","No"). Upload a sample workbook if you stuck. Thanks.

Regards,
DILIPandey
<click on below * if this helps>