if usage based on two ranges NO sum required
On Oct 30, 2:43 pm, 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?
Try...
C2, copied down:
=IF(ISNUMBER(MATCH(B2,$A$2:$A$5,0)),"Yes","No")
Hope this helps!
|