• 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.

Using Vlookup with Data Validation

Also, what actual input do they fill out once they've selected something? i.e. are they putting in quantity, or customer details, etc?
 
It also strikes me that with a bit of clever rearrangement, you could use a PivotTable to serve up this information. THey would merely have to select the category from a slicer or PivotTable Dropdown, and all the relevant attributes for that category would appear across the top. THen you could still use dropdowns like you have to dynamically work out what is relevent given each attribute header.
 
By the way, a fully dynamic formula to serve up the validation lists shouldn't present me too much problem, so there will be no need to use that Product Attributes sheet at all.

THat said, it might pay if you could clarify how the Master Data sheet gets populated. Automatically? Or do you (or someone else) have to paste this data in one category at a time from another system?

Bedtime here now.
 
Jeff thanks for all your comments and interest. As it's your bedtime, I will take a moment to read and consider what you've written, and I'll try to write up something really clarifying.

I really do thank you for your interest and assistance.
 
You must log in or register to reply here.
Back
Top