View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
stephiesunny stephiesunny is offline
external usenet poster
 
Posts: 1
Default Vendor Name Lookup

Vendor Name
ABC Programming
ABC Programming
ABS Imaging
ABC Programming
ACP Services
ABC Programming

What would be the formula that searches this column of vendor names by
looking at the first 6 characters/letters and returns a "True" if there is
another vendor name that is similar, or a "False" if it is not. I can't put
in the exact lookup since it varies from cell to cell.

Thanks!!