Hello, I am needing some serious help! I have spent quite a while trying to research and figure out how to create a spreadsheet to estimate products for my home based business. I have my spreadsheet formatted the way I need it and I have one version that does data validation based on item (which fills in the adjoining cell). But I need to take it a step further. I am needing the following:
Column B (Category) (ie. Lumber, Supply, Finishes, etc.)
Column C (Store) (**based on what category was previously chosen)
Column D (Material) (**based on what category and store was chosen)
So what I am trying to do is pick a category, have column C populate the drop down list by which stores carry items in that category. Furthermore, have column D populate my materials based on what items are available at the store (chosen by column C.) So when its all entered then the price, quantity per price populate using the date from my lists.
I have created my tables in the spreadsheet that show all those items. The goal is to have the lookup function retrieve the information in columns E, F, and H based on what is put in prior. Now, the original way I had this set up, all the items were under one column and the lookup function pulled from that. As you can imagine, my drop down list was ridiculously long. Hints, why I am trying to drill this down and make it more user friendly. I have attached a copy of the spreadsheet to show what I am working with. If anyone could help, fix or offer advise it would be greatly appreciated.