+ Reply to Thread
Results 1 to 15 of 15

drop down list that selects corresponding value instead

  1. 07-03-2014, 10:56 AM #1
    sonny.thind
    sonny.thind is offline
    Forum Contributor
    Join Date
    07-04-2011
    Location
    London, Ontario
    MS-Off Ver
    Excel 365
    Posts
    119

    drop down list that selects corresponding value instead

    Hi,
    i am trying to set up a data validation list for the user to select the options from the 'reason' column' but the input in the box would be the 'code' corresponding to the reason
    i.e drop down list would show me the' reasons' but when selected it would input the 'Code' only
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-03-2014, 11:56 AM #2
    Ace_XL
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: drop down list that selects corresponding value instead

    Cant you have the ode in a separate column?

    =INDEX(DATa!B:B,MATCH(B2,DATa!A:A,0))

    If not you'd need VBA
    Life's a spreadsheet, Excel!
    Say thanks, Click *
    Reply With QuoteRegister To Reply
  3. 07-03-2014, 12:20 PM #3
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: drop down list that selects corresponding value instead

    Hi Sonny..
    got the near solution...
    check the attachment..

    Waiting for * click ..
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 07-03-2014, 12:39 PM #4
    sonny.thind
    sonny.thind is offline
    Forum Contributor
    Join Date
    07-04-2011
    Location
    London, Ontario
    MS-Off Ver
    Excel 365
    Posts
    119

    Re: drop down list that selects corresponding value instead

    Hi guys,
    The reason is that i am trying to avoid another column ,or how would this be solved with VBA?
    Reply With QuoteRegister To Reply
  5. 07-03-2014, 12:46 PM #5
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: drop down list that selects corresponding value instead

    Hi,

    What is the relation between the Item A in "Product" column & Status Column in main Sheet and the relation for "Product" column in main Sheet & "Code" Column in Data Sheet.

    Punnam
    Reply With QuoteRegister To Reply
  6. 07-03-2014, 01:33 PM #6
    sonny.thind
    sonny.thind is offline
    Forum Contributor
    Join Date
    07-04-2011
    Location
    London, Ontario
    MS-Off Ver
    Excel 365
    Posts
    119

    Re: drop down list that selects corresponding value instead

    the product column is a dynamic column which is random data ( user inputted). I just want the user to select the 'Reason' for returning the product to (making it easier to identify the issue correctly so that the right code is entered into the sheet.The specific 'code' needs to be correctly identified.

    FYI only..the 'code' is later converted to a bar code hence the need for it to be accurate..
    Reply With QuoteRegister To Reply
  7. 07-03-2014, 01:39 PM #7
    Punnam
    Punnam is offline
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: drop down list that selects corresponding value instead

    in that case u can go with Vikas_Gautam Post 3

    Punnam
    Reply With QuoteRegister To Reply
  8. 07-03-2014, 03:29 PM #8
    sonny.thind
    sonny.thind is offline
    Forum Contributor
    Join Date
    07-04-2011
    Location
    London, Ontario
    MS-Off Ver
    Excel 365
    Posts
    119

    Re: drop down list that selects corresponding value instead

    Hi punnam,
    this is still another column though right? maybe i need another column if nothing else is possible??
    Reply With QuoteRegister To Reply
  9. 07-04-2014, 04:29 AM #9
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: drop down list that selects corresponding value instead

    yeah Sonny...
    you have to use another column to get it done...?


    Say Thanks, Click *
    Last edited by Vikas_Gautam; 07-04-2014 at 04:40 AM.
    Reply With QuoteRegister To Reply
  10. 07-04-2014, 08:03 AM #10
    Hawkeye16
    Hawkeye16 is offline
    Valued Forum Contributor Hawkeye16's Avatar
    Join Date
    02-27-2013
    Location
    Holland
    MS-Off Ver
    ├•┤ Pew Pew
    Posts
    441

    Re: drop down list that selects corresponding value instead

    It can be done without any helper rows, let me know if this works for you.
    Attached Files Attached Files
    Despite the high cost of living, it remains very popular.

    Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!
    Reply With QuoteRegister To Reply
  11. 07-04-2014, 08:06 AM #11
    Vikas_Gautam
    Vikas_Gautam is offline
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: drop down list that selects corresponding value instead

    Hawkeye..

    where is the formula..
    Reply With QuoteRegister To Reply
  12. 07-04-2014, 08:09 AM #12
    Hawkeye16
    Hawkeye16 is offline
    Valued Forum Contributor Hawkeye16's Avatar
    Join Date
    02-27-2013
    Location
    Holland
    MS-Off Ver
    ├•┤ Pew Pew
    Posts
    441

    Re: drop down list that selects corresponding value instead

    It is code that only runs when cells B2:B5 change on the MAIN tab. Just a basic lookup and change.
    Reply With QuoteRegister To Reply
  13. 07-04-2014, 10:15 AM #13
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: drop down list that selects corresponding value instead

    Quote Originally Posted by sonny.thind View Post
    Hi guys,
    The reason is that i am trying to avoid another column ,or how would this be solved with VBA?
    There is a sample file here:

    http://www.contextures.com/excelfiles.html#DataVal

    Scroll down about a third of the page and look for:

    DV0004 - Data Validation Change
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  14. 07-09-2014, 09:26 AM #14
    sonny.thind
    sonny.thind is offline
    Forum Contributor
    Join Date
    07-04-2011
    Location
    London, Ontario
    MS-Off Ver
    Excel 365
    Posts
    119

    Re: drop down list that selects corresponding value instead

    hey that's awesome the contextures thingy actually answers the issue.. ill close this thread.. thanks a lot guys..
    Reply With QuoteRegister To Reply
  15. 07-09-2014, 07:57 PM #15
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: drop down list that selects corresponding value instead

    You're welcome. Thanks for the feedback!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How would i populate a master sheet based on a drop down selection that selects other
    By dbravo in forum Excel General
    Replies: 2
    Last Post: 05-02-2014, 04:56 PM
  2. [SOLVED] Populating a cell based on what the user selects from a drop down
    By Chuck_N in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-07-2014, 12:54 PM
  3. Drop Down Box Choice Selects Volume Function
    By Tony Pass in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-29-2013, 01:40 AM
  4. [SOLVED] Running a specific macro when someone selects from the drop down list
    By akwishestofish in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2012, 12:56 PM
  5. Combo Box List Selects Wrong Data
    By humboldtguy in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 05-07-2010, 11:23 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1