Hard to explain, but should be easy for Excel pro's:
Say I have a column of values in A, and a column of values in B.
A B C
1 4 yes
2 1 yes
3 2 yes
4 3 yes
5 11 no
6 18 no
7 28 no
8 0 no
9 56 no
In column C, I would like a "yes" or "no" returned. The condition would be if the value in B1 is found in the list A1:A9, return yes, else no, as demonstrated above. And then carry on down the list.
Thanks!
Bookmarks