| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get last 6 rows in list where 1 cell matches certain criteria | New Users to Excel | |||
| Two Matches, then Sumproduct of Values | Excel Worksheet Functions | |||
| Add up Values if Find Matches x 2 | Excel Worksheet Functions | |||
| how to get values from different sheet when info. matches? | Excel Worksheet Functions | |||
| V-lookup and summing values if more than 1 matches criteria | Excel Worksheet Functions | |||
Threaded Mode
