U cld do the same thing with a standard nested formula, of course,
assuming that the format of TRKCASE for the 1st 11 digits will always
be 5 digits "/" 5 digits.

=VLOOKUP(MID($B8,7,5),$E$4:$E$1999,2,FALSE)

This vlookup grabs the "NQFXO" in TRKCASE using the MID() function and
then searches for it in MSO# and then returns the corresponding order.

While testing out the sample data u provided I noticed that the last
MSO# had "NQFX - zero" whilst the TRKCASE had the zero as a the
alphabet O...

Cheers.


--
terabar
------------------------------------------------------------------------
terabar's Profile: http://www.excelforum.com/member.php...o&userid=24272
View this thread: http://www.excelforum.com/showthread...hreadid=379165