May 11 2020 04:33 AM
Dear Team,
I recently learned the dynamic arrays approach to creating dependent dropboxes using the unique and filter functions.
Please assist in solving a problem I am facing:
I need to have a few pairs of dependent dropboxes that have their choices from the same database. for example, if we use the division and app example from the lesson, I need to have a product that contains a table with three records: each record is comprised according to the following pic:
May 11 2020 09:13 AM
May 12 2020 03:04 AM
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.
May 12 2020 03:30 AM
@ShimonGeiman Perhaps like demonstrated attached?
May 12 2020 08:57 AM
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
May 12 2020 10:44 PM
Solution@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.
May 12 2020 10:44 PM
Solution@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.