+ Reply to Thread
Results 1 to 6 of 6

IF formula: If item from list in adjacent cell is picked, a certain value is inserted

  1. #1
    Registered User
    Join Date
    07-01-2019
    Location
    Seattle, WA
    MS-Off Ver
    365
    Posts
    3

    IF formula: If item from list in adjacent cell is picked, a certain value is inserted

    Hi! I am having trouble with this formula. I have a data validation drop down list in one cell that has the following choices:

    Not contacted yet
    Contacted: awaiting answer
    Meeting has been set up
    Converted into New Affiliate!
    Contacted: Not interested

    Next to that, I want a value listed for each choice so that i can do a pie chart. The values would be:

    Not contacted yet- 0
    Contacted: awaiting answer- 10
    Meeting has been set up- 20
    Converted into New Affiliate!- 30
    Contacted: Not interested- 5

    This is the formula I came up with, but it's not working. What do you guys think?


    =IF((OR(C3>="Not contacted yet", "Contacted: awaiting answer","Meeting has been set up","Converted into New Affiliate!", "Contacted: Not interested")), "0", "10","20","30","5"))))

  2. #2
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: IF formula: If item from list in adjacent cell is picked, a certain value is inserted

    Hi

    Try this
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    To help you by my post? it would be nice to click on to say "Thank you".
    If you are happy with a solution to your problem?
    Click Thread Tools above your first post,
    select "Mark your thread as Solved".

  3. #3
    Registered User
    Join Date
    07-01-2019
    Location
    Seattle, WA
    MS-Off Ver
    365
    Posts
    3

    Re: IF formula: If item from list in adjacent cell is picked, a certain value is inserted

    Thanks for replying! Unfortunately, that just populates the cell with a copy of the adjacent cell.

  4. #4
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: IF formula: If item from list in adjacent cell is picked, a certain value is inserted

    Work fine on my side

    See the file
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-01-2019
    Location
    Seattle, WA
    MS-Off Ver
    365
    Posts
    3

    Re: IF formula: If item from list in adjacent cell is picked, a certain value is inserted

    Oh, you're right! I'm sorry, I pasted it in the wrong place. You are a genius! Thank you!!!

  6. #6
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: IF formula: If item from list in adjacent cell is picked, a certain value is inserted

    You welcome

    Thank you for Rep

    cheers
    Last edited by micope21; 07-01-2019 at 02:16 PM.

+ 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. Replies: 2
    Last Post: 08-08-2014, 06:27 AM
  2. [SOLVED] picklist item disable the selection when already picked
    By russkris in forum Excel General
    Replies: 13
    Last Post: 11-26-2013, 10:15 AM
  3. Formula to show an adjacent cell to the one picked in a data validation list
    By sengatwork in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-14-2013, 02:30 PM
  4. Copying each item in a list to a newly inserted row directly below
    By eonizuka in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2009, 11:59 PM
  5. Replies: 1
    Last Post: 01-18-2008, 07:01 PM
  6. Multiselect Listbox - identify if item picked
    By apndas in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-26-2006, 10:25 PM
  7. If certain item is picked, then text added...
    By roger_home in forum Excel General
    Replies: 6
    Last Post: 02-12-2006, 06:39 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