• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Use a drop down list to get all SKU's that relate to it

melvin

Member
Hi Folks,

Hope everyone is having a great day. I am trying to use a drop down which has brand names. Once the brand is selected it should give me a list of all SKU's under the brand.

Would appreciate any help. I have attached a file to display what I am looking for.


Melv.
 

Attachments

  • Drop down question.xlsx
    10.1 KB · Views: 0
You need to create 3 named ranges.
upload_2015-7-30_23-17-52.png
Then use data validation to set A2, Lists =Brands
For B2 data validation Lists =INDIRECT(A2)
upload_2015-7-30_23-19-40.png
 

Attachments

  • Drop down question_Indirect.xlsx
    9.6 KB · Views: 0
Thanks Chihiro,

I believe I wouldn't have articulated my question correctly.

If I choose the drop down as Shirts in cell A2, I would like B2, B3, B4, B5 to populate with Small shirt, Long shirt , Medium shirt, Other Shirt.
 
Back
Top