In general, is the last model always the newest?

Try:

=LOOKUP(2,1/($A$2:$A$7=A11),$B$2:$B$7)