Help with list of values

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.
---