I'm going to try this again... IF/THEN issue
Results 1 to 4 of 4

Thread: I'm going to try this again... IF/THEN issue
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jan 2005
    Location
    Michigan
    Posts
    188
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default I'm going to try this again... IF/THEN issue

    I need a formula for cell D2.

    I apologize but not using excel frequently I have lost so much knowledge I had before with an IF/THEN statement.

    I'm making a spreadsheet (simple) with B2 being a validation cell with LIST. In the list are the following...
    TAGS - Metal Detectable Hardback
    TAGS - Non-MD Hardback
    TAGS - VINYL
    PLACARDS - Metal Detectable Hardback
    PLACARDS - Non-MD Hardback
    PLACARDS - VINYL
    OTHER

    Now in D2, I will have the following values for whatever B2 will display. ex. If I pull-down the menu in B2 for "TAGS - Non-MD Hardback" it should display $2.50 in cell D2. If I pull-down the menu in B2 for "PLACARDS - Metal Detectable Hardback" it should display $31.50 in cell D2, etc.

    The values in the same order for items in B2 are...
    $3.50
    $2.50
    $2.00
    $31.50
    $18.00
    $12.50


    I hope this makes sense. Thank you for understanding and assisting with this formula.

    Thank you and God bless,
    Craig
    0 0
     

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    27,058
    Post Thanks / Like
    Mentioned
    461 Post(s)
    Tagged
    46 Thread(s)

    Default Re: I'm going to try this again... IF/THEN issue

    Are you happy creating a lookup table?
    That way you could just use a Vlookup or index/match formula to return the values.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10
    0 0
     

  3. #3
    MrExcel MVP
    Join Date
    May 2009
    Posts
    16,393
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    8 Thread(s)

    Default Re: I'm going to try this again... IF/THEN issue

    Joe

    When I was a young man I knew everything. Now that I'm older, I realize I know very little, and what I do know, I tend to forget!
    0 0
     

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    27,058
    Post Thanks / Like
    Mentioned
    461 Post(s)
    Tagged
    46 Thread(s)

    Default Re: I'm going to try this again... IF/THEN issue

    Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
    Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10
    0 0
     

Some videos you may like

User Tag List

Tags for this Thread

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
  •