B Rucks presented the following explanation :
Is there a way to use an If statement to see if a cell value is equal to
any value in the list and return a "yes" if true or "no" if false? The
list is in the same worksheet.
Take a look at the LOOKUP functions in online help. You can use one of
those to check the list range combined with...
IF(NOT(ISERROR(?LOOKUP(...))))
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc