+ Reply to Thread
Results 1 to 5 of 5

Populating Cells using Variables from Drop Down Menu

  1. #1
    Registered User
    Join Date
    10-17-2013
    Location
    Grand Canyon, AZ
    MS-Off Ver
    Excel 2010
    Posts
    2

    Populating Cells using Variables from Drop Down Menu

    I am trying to create a formula that will put in a series of numbers into cells based on what the user picks on a drop-down menu.

    This is a picture of the values that I want to import with the second picture being the desired final results (though it's the wrong name, that should be Platemail Armor).

    Excel4.jpg - Putting information into cell Y3 by using cell Y2's value in...
    Excel3.jpg - cell N2 because it is from N1

    Anyone able to help on this?

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Populating Cells using Variables from Drop Down Menu

    I think your pics uploaded backwards. As I understand it, Excel3.jpg is your lookup table, and Excel4 is where the dropdown selection is in Y2, and then you want Y3:Y7 to populate from the lookup table. Is that correct?

    If so, use HLOOKUP. Probably easier if you had included your file instead of pics, but it would essentially be something like:
    =HLOOKUP($Y$2,SheetWithTable!$B$1:$Q$6,2,FALSE)
    Note that the 2 would need to change based upon which value you are looking for in the table, so, in your example, it would range from 2 to 6.
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,239

    Re: Populating Cells using Variables from Drop Down Menu

    Hi and welcome ot the forum

    Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    10-17-2013
    Location
    Grand Canyon, AZ
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Populating Cells using Variables from Drop Down Menu

    Oh, I totally should have just posted the file... here it is!

    ArmorCalculator-1.4.xlsx

    So Y2 is going to be a drop-down list that is pulled from the Values tab B2-Q2, from that I want to have the drop-down insert the cells directly below it (B2-B6 if they chose B1, C2-C6 if they chose C1, etc..). I've tried a lot of tutorials out there, but I just can't seem to find out how to do this.

    I did try that formula you posted Pauleyb, but it didn't seem to work. If I can see how it works then I can figure it out using reverse engineering, but I'm just not skilled enough in Excel to make it work any other way.

    Thanks!

  5. #5
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Populating Cells using Variables from Drop Down Menu

    Not sure how you typed it in. As listed, changes still needed to be made (such as the sheet name). This works I believe:
    Attached Files Attached Files

+ 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. Conditional Drop Down Menu - multiple variables
    By mattmega4 in forum Excel General
    Replies: 7
    Last Post: 07-10-2015, 10:27 AM
  2. Replies: 3
    Last Post: 09-07-2013, 12:31 AM
  3. [SOLVED] Populating a drop down list dependent on multiple matching variables
    By Sardaukar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-28-2013, 02:48 AM
  4. Drop down menu variables?
    By brandonlaw in forum Excel General
    Replies: 2
    Last Post: 08-03-2012, 10:01 AM
  5. Drop Down Menu populating Cost box issue
    By shawnrodgers in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-02-2012, 03:41 AM

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