+ Reply to Thread
Results 1 to 6 of 6

Help: How do I have a drop-down cell auto-populate other cells based on result?

  1. #1
    Registered User
    Join Date
    02-15-2014
    Location
    Teesside, England.
    MS-Off Ver
    Excel 2007
    Posts
    3

    Help: How do I have a drop-down cell auto-populate other cells based on result?

    Hi all,

    Summary
    I work in a customer service environment and we're adding upselling into the mix, but I need a sheet that the guys can fill in quickly to track their commissions. Ideally the fewer cells needing population the better as filling the end product with some degree of speed will be necessary.

    Detail
    I have a list of products, each one corresponds to a commission value. I want to have the products in a drop-down (already done) and to have that selection populate another column with pre-determined commission amount (not done), which will then be totalled elsewhere.

    In addition to that, I want another drop down (Yes/no) to qualify whether the figures are entered at all. I.e., if this cell is no, commission = 0. If this cell is yes, read and populate the commission from a table.

    I've uploaded what I cobbled together so far - I haven't used Excel beyond the most basic level in a VERY long time, so hats off to you experts; I forgot how in depth these things can go.

    Any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,904

    Re: Help: How do I have a drop-down cell auto-populate other cells based on result?

    Try this in cell F3 and copy down as needed.

    =IF(E3="Yes",VLOOKUP(D3,'DO NOT DELETE'!$A$2:$B$5,2,FALSE),0)

    Does that do what you need?

  3. #3
    Valued Forum Contributor AZ-XL's Avatar
    Join Date
    03-22-2013
    Location
    Azerbaijan, Baku
    MS-Off Ver
    Excel 2007
    Posts
    603

    Re: Help: How do I have a drop-down cell auto-populate other cells based on result?

    Hi
    This is just an alternative solution
    =(E3="Yes")*INDEX('DO NOT DELETE'!B:B,MATCH(Sheet3!D3,'DO NOT DELETE'!A:A,0))
    Appreciate the help? CLICK *

  4. #4
    Registered User
    Join Date
    02-15-2014
    Location
    Teesside, England.
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Help: How do I have a drop-down cell auto-populate other cells based on result?

    Quote Originally Posted by BadlySpelledBuoy View Post
    Does that do what you need?
    It does! Thanks a bunch - absolute witchcraft as far as I'm concerned hahah, but thank you so much for your quick response. Exactly as I needed.

  5. #5
    Registered User
    Join Date
    02-15-2014
    Location
    Teesside, England.
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Help: How do I have a drop-down cell auto-populate other cells based on result?

    Quote Originally Posted by AZ-XL View Post
    This is just an alternative solution
    =(E3="Yes")*INDEX('DO NOT DELETE'!B:B,MATCH(Sheet3!D3,'DO NOT DELETE'!A:A,0))
    Also works, thank you.

    You guys are great

  6. #6
    Valued Forum Contributor AZ-XL's Avatar
    Join Date
    03-22-2013
    Location
    Azerbaijan, Baku
    MS-Off Ver
    Excel 2007
    Posts
    603

    Re: Help: How do I have a drop-down cell auto-populate other cells based on result?

    You are welcome. Thank you for feedback

+ 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. [SOLVED] Can I Auto populate cells based on value in another cell
    By Rednecknerd in forum Excel General
    Replies: 2
    Last Post: 12-11-2013, 10:58 AM
  2. Auto Populate cell based on Drop Down list in another cell (VLookup)
    By alialmoore in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-27-2013, 04:07 PM
  3. Replies: 17
    Last Post: 02-05-2013, 08:20 PM
  4. Replies: 3
    Last Post: 02-28-2012, 11:54 AM
  5. Replies: 3
    Last Post: 01-13-2006, 04:30 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