If your "S" values are in Q2:Q43 try
=IF(LEFT(D2,5)>"S2290",99,MATCH(LEFT(D2,5),$Q2:$Q43))
If your "S" values are in Q2:Q43 try
=IF(LEFT(D2,5)>"S2290",99,MATCH(LEFT(D2,5),$Q2:$Q43))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks