I have multiple products, each with various features. I would like to choose a product from a dropdown list and then populate its features below, then do the same for a second product next to it.
My product table looks something like this:
And I have something like this in mind for the dropdowns:
What formula can I use to populate the features of each of the products to compare? I tried using
SUMIF but to no avail.