LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Look up and match Vendor name in one cell of worksheet from list ofmultiple Vendor names in column of other worksheet insitedge Excel Worksheet Functions 2 March 11th 08 11:36 PM
Add numbers belonging to a vendor The Fool on the Hill Excel Discussion (Misc queries) 4 October 14th 07 01:45 AM
Creating a Vendor ID from Vendor Name... Donald King Excel Worksheet Functions 4 November 6th 06 10:01 PM
How do I set up a way to keep track of vendor invoices? JoAnneCH Excel Worksheet Functions 2 July 24th 06 09:41 PM
INSERT LINE after Vendor name change Rashid Excel Worksheet Functions 3 April 27th 05 06:18 PM


All times are GMT +1. The time now is 05:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"