Help with list of values

**teelim** · 09-23-2006, 01:47 PM

hmmmm... sounds quite confusing...

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

**Billx** · 09-24-2006, 04:26 AM

Hi,

No problems, I would be grateful for any help.

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

Regards,

**Bryan Hessey** · 09-24-2006, 09:36 AM

Originally Posted by Billx

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** · 09-24-2006, 01:25 PM

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,