A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

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



 
 
Thread Tools Display Modes
  #1  
Old August 14th 09, 06:34 PM posted to microsoft.public.excel.misc
Simon
external usenet poster
 
Posts: 172
Default 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")
Ads
  #2  
Old August 14th 09, 06:38 PM posted to microsoft.public.excel.misc
Bob Umlas[_3_]
external usenet poster
 
Posts: 320
Default 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")



  #3  
Old August 14th 09, 07:03 PM posted to microsoft.public.excel.misc
Simon
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")

>
>
>

  #4  
Old August 14th 09, 09:01 PM posted to microsoft.public.excel.misc
Ron Rosenfeld
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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Get last 6 rows in list where 1 cell matches certain criteria Struggling in Sheffield[_2_] New Users to Excel 2 March 13th 09 12:54 AM
Two Matches, then Sumproduct of Values ryguy7272 Excel Worksheet Functions 16 February 19th 09 03:08 PM
Add up Values if Find Matches x 2 Sean Excel Worksheet Functions 9 November 16th 07 12:21 PM
how to get values from different sheet when info. matches? juanpauk Excel Worksheet Functions 3 March 2nd 06 07:02 PM
V-lookup and summing values if more than 1 matches criteria holcay Excel Worksheet Functions 3 February 6th 06 03:52 PM


All times are GMT +1. The time now is 11:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.