If a cell matches a list of values......
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 a cell matches a list of values......
=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") |
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") |
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 |
All times are GMT +1. The time now is 11:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com