View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CapFSU CapFSU is offline
external usenet poster
 
Posts: 2
Default LOOKUP between two columns of diff. size

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?