Look up

[dantb]

What I have is two columns of numbers. Column A, in numbered from 1 to 100. Column B is a partial listing of column A, like. 1 2 3 5 8 12 24. What I am trying to do if possible, is after imputing the numbers in column B, is in column C, just have like a yes or no show up next to the corresponding number in the list. This way I can delete the records that I do not need. So if I type “5” in column B, a yes would show up in column C, next to column B’s 5.

[zzydhf]

in c1:
=if(isna(match(b1,$a$1:$a$100,0)),"No","Yes")

[Asala42]

Hey,

What I have is two columns of numbers. Column A, in numbered from 1 to 100. Column B is a partial listing of column A, like. 1 2 3 5 8 12 24. What I am trying to do if possible, is after imputing the numbers in column B, is in column C, just have like a yes or no show up next to the corresponding number in the list. This way I can delete the records that I do not need. So if I type “5” in column B, a yes would show up in column C, next to column B’s 5.

How about:

=IF(COUNTIF($A$2:$A$100,B2)>0,"yes","no")

Adam

[dantb]

Thanks ZZ & as, both formulas do work,but put the yes across from the number that I typed in.The trick I was looking for is haveing it put the yes, across from where it found the number in column A. Cant figure out how to go about it.

[Asala42]

Try the reverse (well kind of reverse anyway). Copy this down C:

=IF(COUNTIF($B$2:$B$100,A2)>0,"yes","no")

Adam

[zzydhf]

the reverse should work for mine as well:
=if(isna(match(a1,$b$1:$b$100,0)),"No","Yes")

copy down column c

[dantb]

I think that did it Asala42, Thanks so much for you help. Dan !