Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 24

Thread: Get List Of All Values Corresponding To A Value In The Adjacent Column

  1. #11
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Yeah, so what's your criteria for showing 2, 5 or 4? Is it based on color?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  2. #12
    Junior Member
    Join Date
    Mar 2014
    Posts
    27
    Rep Power
    0
    Not on the basis of color ?
    But the color developed by I want to clarify the value corresponding to this condition
    Even if the condition repeats in the column
    Unfortunately, once again the lack of my ability the explanation

  3. #13
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Unless you are able to clearly explain what you need, the volunteers will not be able to help you. Could you find someone in your circle who can translate your requirements in a meaningful way, and not just transliterate what you are saying.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  4. #14
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    13
    Add dropdown in the sheet and select data as the source of drop down and select value based on the selection and position you will get the value that's it.

  5. #15
    Junior Member
    Join Date
    Mar 2014
    Posts
    27
    Rep Power
    0
    Without tiredness
    Can you give me an example
    Because I need this necessary
    Has not been realized yet that I want

  6. #16
    Junior Member
    Join Date
    Mar 2014
    Posts
    27
    Rep Power
    0
    Mister, "Fox"
    My request is very simple
    I want value in column "B", appear when I write the corresponding value in the column "A" even at repeat that value
    - When I write the value "M1" in the cell, "A 1" in the column "A", comes the value "2" only and not all the other values
    Such as " 5 , 4 ", etc.

  7. #17
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    Sure. Try this.
    Attached Files Attached Files
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  8. #18
    Junior Member
    Join Date
    Mar 2014
    Posts
    27
    Rep Power
    0
    Unfortunately, Mister, "Fox"
    The solution is great, but I want only one value appears in cell "d 1" with the value of the corresponding
    And is not merged
    This is the difficulty that I face, a similarity condition
    Thanks again
    But it is clear that it is difficult

  9. #19
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    But I had already given you a solution with one value each. And there are a few other solutions in this thread which gives you only one value. And just now, I've given you a solution which gives all the list in one cell, separated by a comma (,). I have now run out of any assumptions of what you need without you being able to explain clearly what you need.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  10. #20
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    If any of the developers/members out there can add any more inputs which may give more clarity to the OPs request, would be great.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

Similar Threads

  1. Fill Combobox Based On Values In Adjacent Column
    By rydysh in forum Excel Help
    Replies: 5
    Last Post: 10-03-2013, 07:27 AM
  2. Replies: 6
    Last Post: 05-22-2013, 02:23 AM
  3. Replies: 16
    Last Post: 04-19-2013, 08:20 PM
  4. Copy Row To A New Sheet If A Value Found In Adjacent Column
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 4
    Last Post: 08-17-2012, 05:42 PM
  5. Replies: 3
    Last Post: 08-05-2012, 09:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •