Index / Match / Large based on a criteria.

try in L12

=LARGE(IF($A$7:$A$15=K12,$C$7:$C$15),J12)

This is an array formula and needs to be confirmed with Ctrl-Shift-Enter. Then copy down. Copy the formula to L25 and copy down.

try in M12
=INDEX($B$7:$B$15,MATCH(K12&L12,INDEX($A$7:$A$15&$C$7:$C$15,0),0))

try in N12
=INDEX($F$7:$F$15,MATCH(K12&L12,INDEX($A$7:$A$15&$C$7:$C$15,0),0))

Copy down and copy to the "Blue" section as well. The nested Match formula combines the model name with the price effect, so you don't get wrong results if, for example red and blue both have a price effect of 12. With a simple lookup on just the price effect number, you'd see only the first occurrence rather than the correct occurrence.