checking a value..

  • Thread starter Thread starter demolay
  • Start date Start date
D

demolay

i want to check whether a values exists in a column or not. if exists,
want to right "yes". if not, "no".
how can i scan a column and return "yes" or "no" in another cell.
for example
column a------------------column b
juve shirt numbers------milan shirt numbers
1---------------------------1
2---------------------------5
4---------------------------6
5---------------------------7
7---------------------------8
9---------------------------9
10-------------------------10
....

i want to look for "1" in column b and write "yes" in column c. the
look for "2" in column b and write "no" in column c...
i think you got it :
 
=IF(COUNTIF($B$2:$B$8,A2)>0,"yes","no")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
i want to check whether a values exists in a column or not. if exists, i
want to right "yes". if not, "no".
Click to expand...

=IF(ISNA(VLOOKUP(A2,$B$2:$B$8,1,FALSE),"no","yes")
 
Back
Top