Thanks, works great.

How do I read this? I see the range ref and check against B2. . . then???

I figure if I understand what it says, I can move towards my own excel
solutions.

Ross

"Elkar" wrote:

Try this:

=IF(COUNTIF($A$2:$A$5,B2)0,"Yes","No")

HTH,
Elkar


"ross" wrote:

COL_A COL_B COL_C
2 1 Yes
2 1 Yes
2 2 Yes
1 3 No
I need to have COL_C say yes if any value in COL_B = any value in COL_A.
I tried the following: =if($A$2:$A$5=B2, "yes", "no") . . . didn't work. :(
I read the formula as "if range a2 to a5 = B2, then say yes. . .

Any ideas?