View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Simon Simon is offline
external usenet poster
 
Posts: 172
Default If a cell matches a list of values......

Bob you are a god!!! Thanks very much

"Bob Umlas" wrote:

=IF(NOT(ISNA(MATCH(A18,{"40DK216","40DK720","40DK7 39","40DK747","40DK814","40DK945","40DKA63","40DKB 83","40DKC31","40DKC63"},0))),"ALERT/EVAC","NADA")
"Simon" wrote in message
...
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")