+ Reply to Thread
Results 1 to 4 of 4

referencing a dropdown option that populates a formula

  1. #1
    Registered User
    Join Date
    01-02-2018
    Location
    North Carolina
    MS-Off Ver
    MS Office 10
    Posts
    4

    referencing a dropdown option that populates a formula

    Hi

    I'll be brief since this system has already deleted my post once.....gr

    I have 5 columns
    e - debits
    f - credits
    g - column - with drop down (validity) with 4 options (accounts)
    j - account 1 from drop down
    k - account 2 from drop down

    J and K are accounts that I am keeping a running balance on, but they are separate from each other

    what i need is:

    when i select an option from the drop down in G, (if its options 3 or 4 - nothing happens on the spread sheet, cells stay empty) and I choose option J/the words that correspond with J then in column J I want this formula to populate/function (=J4+E8-F8) and for column K to remain empty.

    Conversely if I choose option K/words that correspond with K from the drop down in column G then in column K I want this formula to populate/function (=K4+E8-F8) and for column J to remain empty.


    Hopefully that all makes sense & is possible. Correct J & K formula's as need (obviously )
    thank you! I appreciate it!

    Let me know if you need more on the purpose of the spreadsheet

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,563

    Re: referencing a dropdown option that populates a formula

    it is not easy to write a formula based on the narrative you supplied (a sample sheet with all the options would go a long way to help) but...
    something like =IF(OR(G2=3,G2=4),"",if(J1=???,(J4+E8-F8),IF(K1=???,(K4+E8-F8),"")))
    but you are leaving out a lot of information. What to do with the other two selections from G for example, where does the J account option appear? same for the K account option?
    maybe you can adjust things based on what I've written.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365, rarely 2007
    Posts
    12,673

    Re: referencing a dropdown option that populates a formula

    Hi CCMOM. Welcome to the forum.

    That's a lot of detail to visualize. A sample Excel workbook would help ... not pics or screenshots; saves retyping data. You are also likely to get more/faster response.

    If you are not familiar with how to do this:

    Save yourself some grief. The 'paperclip' attachment icon has not worked for some time.
    Do this instead.

    To attach a file to your post,
    • be sure to desensitize the data
    • click “Go Advanced” (next to Post Quick Reply – bottom right),
    • scroll down until you see “Manage Attachments”, click that,
    • click “Browse”.
    • select your file(s)
    • click “Upload”
    • click “Close window”
    • click “Submit Reply”

    The file name will appear at the bottom of your reply.
    Dave

  4. #4
    Registered User
    Join Date
    01-02-2018
    Location
    North Carolina
    MS-Off Ver
    MS Office 10
    Posts
    4

    Re: referencing a dropdown option that populates a formula

    thanks guys.

    after starring at it for so long its hard to know what is clear and what isnt anymore.
    it's my kids birthday tonight, but i will definitely copy up a sample sheet and submit it back in the next few days. i appreciate your help and try to clarify more what i need.
    thank you so much for you help!

+ 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. Dropdown box suggested list option by typing the first letter of an option
    By jennis7242 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-19-2017, 10:39 PM
  2. Dropdown Populates Two Cells at Once
    By HWScott in forum Excel General
    Replies: 1
    Last Post: 07-23-2016, 12:35 AM
  3. Dropdown menu - autmatically populates
    By capefigaro in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-04-2016, 02:11 PM
  4. Question about making a dropdown box that auto populates
    By Mattyb08 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-24-2015, 08:21 PM
  5. Need Help with VBA code that populates a dropdown in a userform conditionally
    By seannormand in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-10-2014, 09:08 AM
  6. Help a rookie make a dropdown that populates a sheet.
    By DareArkin in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 03-01-2013, 01:47 AM
  7. Userform option button starts a loop that searches worksheet and populates listbox
    By silvertyphoon1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-15-2010, 01:58 AM

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