+ Reply to Thread
Results 1 to 10 of 10

Cell changes dependent upon drop down menu in a different cell

  1. #1
    Registered User
    Join Date
    01-24-2013
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2003
    Posts
    5

    Cell changes dependent upon drop down menu in a different cell

    I am looking for a formula that when I choose one choice in a drop down menu it will change automatically change the answer in two additional cells. The first drop down menu has four choices, however 3 of them will give the same answers in the two additional cells.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Cell changes dependent upon drop down menu in a different cell

    Hello & Welcome to the Forum,

    Not a lot to go on here, but here is an example.

    North, South, East, and West in the drop down of cell A1

    C1 =IF(OR(A1={"North","South","East"}),"Choice One","")
    D1 =IF(A1="West","Choice Two","")
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    01-24-2013
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Cell changes dependent upon drop down menu in a different cell

    Jeff,
    Thanks Jeff for the quickness. Will this work if the additional 2 cells are drop downs as well?

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Cell changes dependent upon drop down menu in a different cell

    No, you can't have both a drop down and a formula in the same cell.

    Did you see my PM?

  5. #5
    Registered User
    Join Date
    01-24-2013
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Cell changes dependent upon drop down menu in a different cell

    Yes... well atleast I think I did. This is the first ever forum I have signed up for. What I am needing is if of the answers in cell one are checked, then cell 2 which is a yes or no question, will equal No. If they equal no, then cell 3 is a question of Good, Bad, None, then cell 3 will equal none. Thanks for your help!!!!!

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Cell changes dependent upon drop down menu in a different cell

    Can you please return a PM to me answering the question I asked?

    As far as your query, can you put together a small sample workbook with a clear before and after?

    I'm not entirely clear on what you mean by checked, but this sounds possible.

  7. #7
    Registered User
    Join Date
    01-24-2013
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Cell changes dependent upon drop down menu in a different cell

    Would you like this before and after sent to your email?

  8. #8
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Cell changes dependent upon drop down menu in a different cell

    No you can attach it here...

    Attach a sample workbook.

    When you are in Advanced reply, click on the paperclip to open the upload window.

    View Pic

  9. #9
    Registered User
    Join Date
    01-24-2013
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Cell changes dependent upon drop down menu in a different cell

    Thanks for getting my name changed!!
    Attached Files Attached Files

  10. #10
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Cell changes dependent upon drop down menu in a different cell

    In D2 >> =IF(OR(C2={"Native","RCF","Transfer"}),"NO","")

    For E2, I see you have a drop down there, but again as stated earlier you can't have a drop down and a formula at the same time.

    So, for E2, what do you want?

    IF Native, RCF, Or Transfer are selected in C2, then D2 would = "NO" and E2 would = "None"
    Do you need the drop down or would the same formula in D2 work?

    Also, if at all possible you should stay away from merging cells...

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1