Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Feb 2015
    Posts
    128
    Thanks
    19
    Thanked 1 Time in 1 Post

    Post On Selecting subcategory from the dropdown respective main category should display in the next colum

    Hi Experts

    Please let me know if this is possible or not. I have a list of sub-category and main category attached in the sample file.

    I will be adding data validation feature in the sub-category. What I want when a user selects respective sub-category from the dropdown then the main category of it should reflect on the cell/colum next to it.

    Regards,
    JD
    Attached Files Attached Files

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,629
    Thanks
    114
    Thanked 644 Times in 588 Posts
    Jaggi,

    The following worksheet uses Index/match formulas to return the Main Category for the sub category you chose through data validation.

    HTH,
    Maud

    Categories.png
    Attached Files Attached Files

  3. #3
    2 Star Lounger
    Join Date
    Feb 2015
    Posts
    128
    Thanks
    19
    Thanked 1 Time in 1 Post
    Hi Maud

    Thanks for the formula.

    Regards,
    JD

  4. #4
    2 Star Lounger
    Join Date
    Feb 2015
    Posts
    128
    Thanks
    19
    Thanked 1 Time in 1 Post
    Hi Maud

    I want to apply data validation in the entire column in the attached file by you say column B. Is it possible to add the same functionality in column A. Whenever anyone select the respective subcate in column B, it main cate should reflect in col A.

    Regards,
    JD

  5. #5
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,629
    Thanks
    114
    Thanked 644 Times in 588 Posts
    Jaggi,

    The data validation in column B and the index/match formula have been extended to row 5000. They can be extended to the last row if desired.

    HTH,
    Maud

    Validation.png
    Attached Files Attached Files

  6. #6
    2 Star Lounger
    Join Date
    Feb 2015
    Posts
    128
    Thanks
    19
    Thanked 1 Time in 1 Post
    Thanks Maud

    Regards,
    JD

Tags for this Thread

Posting Permissions

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