If a cell matches a list of values......

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

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")
 
=IF(NOT(ISNA(MATCH(A18,{"40DK216","40DK720","40DK739","40DK747","40DK814","40DK945","40DKA63","40DKB83","40DKC31","40DKC63"},0))),"ALERT/EVAC","NADA")
 
Bob you are a god!!! Thanks very much

Bob Umlas said:
=IF(NOT(ISNA(MATCH(A18,{"40DK216","40DK720","40DK739","40DK747","40DK814","40DK945","40DKA63","40DKB83","40DKC31","40DKC63"},0))),"ALERT/EVAC","NADA")
Click to expand...
 
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")
Click to expand...

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
 
Back
Top