just to answer your post #3 for what pjwhitfield gave you, adjust the vlookup to this...
=VLOOKUP(K2&L2&M2,D2:E4,2,FALSE)