Do something like this in the 13,000 code sheet::
=vlookup(left(a1,6),sheet1!A:A,1,false)
and copy down.

Adjust your ranges to suit.

Regards,
Fred.

"CapFSU" wrote in message
...
have a sheet w/ list of 80 different 6 digit codes. have a second sheet
w/
over 13,000 8 digit codes. Trying to figure out how to lookup in the
second
list to see if any of the 13,000 first 6 digits of the 8 digit code match
any
of the list of 80. Any ideas?