+ Reply to Thread
Results 1 to 9 of 9

Trying to autofill two colums from one dropdown box please help

  1. #1
    Registered User
    Join Date
    06-26-2013
    Location
    Rotherham
    MS-Off Ver
    Excel 2013
    Posts
    4

    Trying to autofill two colums from one dropdown box please help

    Hi All, I'm quite new to excel formulae and am trying to crate a new order request form for my workplace as I order ink cartridges very regular and have to manually type these up every time.
    I have attached a example of where I have got up to where sheet 1 has my order request form which will calculate my costings but I'm trying to link column A & B to the second sheet (renamed items)
    What I would like is to create a dropdown box in column A to select the code from column A on sheet 2 so that it auto fills the description in on column B from column B on sheet 2.
    I can get the dropdown box for column A to work but can't figure out how to populate Column B from this.

    Any help would be greatly appreciated.

    Thanks
    AaronORDER REQUEST MASTER 2013.xlsx

  2. #2
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: Trying to autofill two colums from one dropdown box please help

    Have a look at the attached. Is this what you mean?
    Attached Files Attached Files
    If I've been of help, please hit the star

  3. #3
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Trying to autofill two colums from one dropdown box please help

    INDEX & MATCH is the way to do it..

    =IFERROR(INDEX(Items!$B$1:$B$20;MATCH(A13;Items!$A$1:$A$20;0));"")
    Attached Files Attached Files
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  4. #4
    Registered User
    Join Date
    06-26-2013
    Location
    Rotherham
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Trying to autofill two colums from one dropdown box please help

    Hi Spencer & Fotis.
    Thanks both of those work perfectly.
    If I could just ask one more question, can this be dynamic so if I add more data to sheet 2 it becomes part of the dropdown choices (ie we get a new printer so need new toner types adding to the list)

    Thanks again

  5. #5
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Trying to autofill two colums from one dropdown box please help

    Yes you can. See 1 very good link for this!

  6. #6
    Registered User
    Join Date
    06-26-2013
    Location
    Rotherham
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Trying to autofill two colums from one dropdown box please help

    Hi again, ignore the final question I've figured it out, but just wanted to say thanks again as this will save me a massive amount of time on day to day ink orders.

    Thanks
    Aaron

  7. #7
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Trying to autofill two colums from one dropdown box please help

    ........................

  8. #8
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: Trying to autofill two colums from one dropdown box please help

    Aaron,

    The attached now has a dynamic data range called "Toner" that will increase as you add new items.
    Note that it will not work properly if you leave blank rows in the data.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    06-26-2013
    Location
    Rotherham
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Trying to autofill two colums from one dropdown box please help

    You just got your reply in before me Fotis
    I'll have a read through the link anyway as I really do need to improve my excel knowledge in general.
    I've added rep for both of you too as you've btoh been a great help

    Thanks
    Aaron
    Last edited by Aaron2104; 06-26-2013 at 05:00 AM.

+ 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