+ Reply to Thread
Results 1 to 5 of 5

If value appears in a range return 1 value, if not return another

  1. 04-21-2011, 11:03 AM #1
    whirlwind1
    whirlwind1 is offline
    Registered User
    Join Date
    04-07-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    11

    If value appears in a range return 1 value, if not return another

    Hi,

    I think this is an easy one but my brain has stopped working.

    What I would like to do is have a formula that returns the value YES if the name entered appears in the list in column A and if it doesn't then return the value in column B.

    Thanks all!
    Attached Files Attached Files
    Last edited by whirlwind1; 04-21-2011 at 11:27 AM.
    Reply With QuoteRegister To Reply
  2. 04-21-2011, 11:17 AM #2
    darkyam
    darkyam is offline
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: If value appears in a range return 1 value, if not return another (An easy 1 I th

    Try =IF(COUNTIF($A$2:$A$5,B7),"Yes","No")
    Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.

    If you like a post, please rate it with the scales icon (top right).
    If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
    Reply With QuoteRegister To Reply
  3. 04-21-2011, 11:21 AM #3
    qinyg
    qinyg is offline
    Registered User
    Join Date
    10-22-2008
    Location
    United States
    Posts
    16

    Re: If value appears in a range return 1 value, if not return another

    =if(iserror(match(b7,$a$2:$a$5,0)),"no","yes")
    Reply With QuoteRegister To Reply
  4. 04-21-2011, 11:22 AM #4
    whirlwind1
    whirlwind1 is offline
    Registered User
    Join Date
    04-07-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: If value appears in a range return 1 value, if not return another

    I seem to get the response "no" everytime but I would expect a "yes" for the first name?
    Reply With QuoteRegister To Reply
  5. 04-21-2011, 11:23 AM #5
    whirlwind1
    whirlwind1 is offline
    Registered User
    Join Date
    04-07-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: If value appears in a range return 1 value, if not return another

    qinyg - you got it!! Perfect - thanks all.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1