Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 14th 09, 06:34 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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")

  #2   Report Post  
Old August 14th 09, 06:38 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2009
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   Report Post  
Old August 14th 09, 07:03 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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   Report Post  
Old August 14th 09, 09:01 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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:22 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017