+ Reply to Thread
Results 1 to 4 of 4

IF, AND Criteria Question

  1. #1
    Forum Contributor
    Join Date
    08-25-2013
    Location
    Virginia, USA
    MS-Off Ver
    Excel 2013
    Posts
    205

    IF, AND Criteria Question

    Is there a formula that will show the data in either column "B" or "C" depending upon value of column "A"? For example, I would like column "D" rows 1,2, and 3 to say "Joe Saunders (L)", "Barry Enright (R), and "Armando Galarraga (R)" because column "A" has the symbol "@", whereas I would like column "D" rows 4,5 and 6 to say "Ian Kennedy (R)", "Daniel Hudson (R)", and "Joe Saunders (L) because column "A" does not have the symbol "@".

    A B C
    @ CHC Joe Saunders (L) Randy Wells (R)
    @ CHC Barry Enright (R) Andrew Cashner (R)
    @ CHC Armando Galarraga (R) Ryan Dempster (R)
    CIN Travis Wood (L) Ian Kennedy (R)
    CIN Bronson Arroyo (R) Daniel Hudson (R)
    CIN Mike Leake (R) Joe Saunders (L)

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: IF, AND Criteria Question

    Maybe..

    =IF(A1="@",B1,C1)

    Copied down
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,585

    Re: IF, AND Criteria Question

    Pl see attached file.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    08-25-2013
    Location
    Virginia, USA
    MS-Off Ver
    Excel 2013
    Posts
    205

    Re: IF, AND Criteria Question

    Yep, that worked!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Question regarding conditional format question that covers two range criteria
    By lilsnoop in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-06-2013, 12:32 PM
  2. Criteria question - AverageIF (if you please)
    By djalexr in forum Excel General
    Replies: 3
    Last Post: 01-14-2011, 08:00 AM
  3. [SOLVED] Criteria based sum question
    By masik in forum Excel General
    Replies: 6
    Last Post: 06-07-2006, 02:35 AM
  4. [SOLVED] SUMIF Question Re:Criteria
    By Dave in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-08-2006, 08:55 AM
  5. [SOLVED] query criteria question
    By Dcbrown428 in forum Excel General
    Replies: 1
    Last Post: 11-18-2005, 01:25 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1