Excel how to find values in 1 column exist in the range of values in another

=COUNTIF($B$2:$B$5,A2)>0

http://stackoverflow.com/questions/18489148/excel-how-to-find-values-in-1-column-exist-in-the-range-of-values-in-another