View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default If a cell matches a list of values......

On Fri, 14 Aug 2009 10:34:10 -0700, Simon
wrote:

Hi there,

I'm not great with excel so I need some help. I want to be able to check a
cell when it is entered against a list of values. If the value entered is an
exact match I want a true value, if it doesn't exactly match i want a false
value. I think I'm close with this. Could somebody please give me some
advice....

=IF(A18={"40DK216","40DK720","40DK739","40DK747", "40DK814","40DK945","40DKA63","40DKB83","40DKC31", "40DKC63"},"ALERT/EVAC","NADA")


You just need to add an OR function:

=IF(OR(A18={"40DK216","40DK720","40DK739","40DK747 ","40DK814","40DK945","40DKA63","40DKB83","40DKC31 ","40DKC63"}),"ALERT/EVAC","NADA")

--ron