If your "S" values are in Q2:Q43 try

=IF(LEFT(D2,5)>"S2290",99,MATCH(LEFT(D2,5),$Q2:$Q43))