G
Guest
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?
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?