Help with list of values

[Billx]

Hi,

I would appreciate your advice; I have a spreadsheet in Excel, which I’m trying to make as easy as possible for users (seriously).

I have three columns and in two of the columns I have a drop down list, how can I get the third column to come up with the answer, however columns one and two have many different combinations. The answer is also in text and not in numbers, examples could be:

Negligible + Moderate = Medium
(Column 1, list of values + Column 2, list of values = Column 3 – this value would just appear).

There are 5 values in each of the list of values in columns 1 and 2, and there combination can equal a total of any 4 in column 3.

I hope the above makes sense, and any help would be appreciated.

Thanks,

[teelim]

hmmmm... sounds quite confusing...

do you mind posting the possible combinations and answers? would make it easier to understand

[Billx]

Hi,

No problems, I would be grateful for any help.

The combinations can only be sourced from the matrix...

Regards,

[Bryan Hessey]

Hi,

No problems, I would be grateful for any help.

The combinations can only be sourced from the matrix...

Regards,

In D3 put:

=IF(ISERROR(INDEX(C$15:G$19,MATCH(B3,B$15:B$19,0),MATCH(C3,C$20:G$20,0))),"",INDEX(C$15:G$19,MATCH(B3,B$15:B$19,0),MATCH(C3,C$20:G$20,0)))

and formula-fill that to D10



ps, the colours are very pretty, and the legend is too, . . . but you need to fill the matrix with data, as per that shown on the legend.
---

[Billx]

Bryan,

Cheers, I have filled the matrix with data and the formula worked in the table worked, this is appreciated.

Does this allow for all of the combinations or do I have to edit any of the code?

Again this is very much appreciated.

Regards,