Checking cell for Number

[Lee]

I have about 200 numbers in column A. I would like to enter any number in
Column B. In column C I would like, it to show if the number is used or free.

can this be done with a if statement?


Thanks

 

[Domenic]

Try...

=IF(COUNTIF($A$1:$A$200,B1),"Used","Free")

If you have a list of numbers in Column B that you'd like to check,
enter the above formula in C1, and copy and paste the formula to your
other cells in Column C.

Hope this helps!

 

[Lee]

Perfect

Thank you

Try...

=IF(COUNTIF($A$1:$A$200,B1),"Used","Free")

If you have a list of numbers in Column B that you'd like to check,
enter the above formula in C1, and copy and paste the formula to your
other cells in Column C.

Hope this helps!