Forum Discussion
dynamic arrays
ShimonGeiman Not sure I get your point, but have attached a slightly revised file where the lists for the dropdowns are now transposed and on to the same row as the item description for each of the categories chosen. Added an extra product to demonstrate what I was thinking of. For the next product, just copy the table and the formulae in N to where ever you want to have your next product.
If this is not what you had in mind, please show an example of how your sheet with 60-70 products really looks like.
Thank you for your vies and. Please find attached an excel file with the problem I wish to solve.
I have a database table in columns B and C. I need to build a Product that comprised of three (or more) items from the database. I would like to have in cells F4# dropboxes that will allow me to choose a category from the category column, and then to choose in a dropbox in cells G4# an Item Description from the relevant category. I have done it for cells f4:G4 using UNIQUE and FILTER formulas, but have no clue how to expand it to lines 5 and 6. Thanks a lot.
ShimonGeiman Perhaps like demonstrated attached?
Thanks a lot Riny, but I am afraid it works for only one product. I need to have 60-70, so the solution is nice but not feasible for many products
ShimonGeiman Not sure I get your point, but have attached a slightly revised file where the lists for the dropdowns are now transposed and on to the same row as the item description for each of the categories chosen. Added an extra product to demonstrate what I was thinking of. For the next product, just copy the table and the formulae in N to where ever you want to have your next product.
If this is not what you had in mind, please show an example of how your sheet with 60-70 products really looks like.
Thank you so much - it works!!!!!
Its a saver
Shimon