Excel 2007 : Formula needed to check if cell data DOESN'T match data in list

Either:

=COUNTIF($A$1:$A$20,$B1)=0

or

=ISNA(MATCH($B1,$A$1:$A$20,0))

Above assumes case insensitive tests ... if you need exact / case sensitive matches (eg Apple <> apple) let us know