Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: dealing with text - I need to set up an IF THEN situation

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am a complete newbie to Excel, so I'm guessing this is a no brainer for most of you.

    I have a column that has a series of state abbreviations. I want to set up a formula in another column that looks at the state abbreviations and basically says "IF E:E = AL, CT, DE, KY, etc. THEN H:H = whatever"

    This seems like such a simple task, but I can't figure it out!

    Help!

    Thanks

    Paul


  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,648
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-15 08:01, paulrus wrote:
    I am a complete newbie to Excel, so I'm guessing this is a no brainer for most of you.

    I have a column that has a series of state abbreviations. I want to set up a formula in another column that looks at the state abbreviations and basically says "IF E:E = AL, CT, DE, KY, etc. THEN H:H = whatever"

    This seems like such a simple task, but I can't figure it out!

    Help!

    Thanks

    Paul
    In H1 enter and copy down:

    =IF(OR(E1={"AL","CT","DE","KY"}),"Whatever","")


  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    THANK YOU!!!
    Of course, I forgot 1/2 of my question.
    the other half would be - if it does not = "Whatever" then it = "Something Else"

    Does that make sense?

    So if it is AL, CT, DE, KY, etc. it = "Whatever" but if it does not = "Whatever" it = "Something Else"....

    Thanks again for the help on this beginner problem!

  4. #4
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Maybe a VLOOKUP?

    Column A - state abbreviations
    Column B - name of states
    In C1 =VLOOKUP(C2,A1:B50,2)

    Enter HI in C2 and C1 returns Hawaii!
    Column A is sorted

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Already figured it out:

    =IF(OR(E1={"AL","CT","DE","KY"}),"Whatever","Something Else")

    Thanks!!!!

  6. #6
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,648
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-15 08:16, paulrus wrote:
    THANK YOU!!!
    Of course, I forgot 1/2 of my question.
    the other half would be - if it does not = "Whatever" then it = "Something Else"

    Does that make sense?

    So if it is AL, CT, DE, KY, etc. it = "Whatever" but if it does not = "Whatever" it = "Something Else"....

    Thanks again for the help on this beginner problem!
    =IF(OR(E1={"AL","CT","DE","KY"}),"Whatever","")

    Last "" is "Something else"; thusly:

    =IF(OR(E1={"AL","CT","DE","KY"}),"Whatever","Something else")

    Examine also what Brian is suggesting.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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