Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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:

enter image description here

And I have something like this in mind for the dropdowns:

enter image description here

What formula can I use to populate the features of each of the products to compare? I tried using SUMIF but to no avail.

share|improve this question
Have a try using INDEX MATCH functions and tell us if you are still stuck – JMax Nov 26 '12 at 9:56
@JMax Please post an answer as this was exactly what I was looking for. – Pieter van Niekerk Nov 26 '12 at 10:24
Glad it helped you :). I've posted it as an answer but feel free to edit it or to add your own answer as described here – JMax Nov 28 '12 at 18:02
up vote 1 down vote accepted

Even if this is not a full working answer, as discussed in the comments, the right way to hande this is to use a combination of INDEX and MATCH functions as described in the given link.

Please feel free to edit this answer (even if you have not the rights yet, it will get approved by mods) with the answer you found by yourself.

share|improve this answer

An HLOOKUP should do the trick. In I3 you would have something like this:


And in I4:


An HLOOKUP is an "horizontal lookup", the not-as-common little brother of VLOOKUP. It picks up your lookup value (Model1), scans the first row of your table (A1:E3) and returns the value in the second row (2). The zero on the end ensures that the text you are searching for is matched exactly (I assume you are referencing real text names and not actually "Model1").

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .