Results 1 to 4 of 4

formula to find where there is no match for a string

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-13-2012
    Location
    ND
    MS-Off Ver
    Excel 2010
    Posts
    152

    formula to find where there is no match for a string

    I have a formula in Column C to make sure the SearchTerm and Customer material have the same number in the string. I need column D to make sure that the Search Term and Customer material has a base. Base is when the SearchTerm and Customer material are equal.

    In the excel file the first data set does not have a base associated as it starts with an alt1 and MFG Obsoloete. It does not contain Customer material 0780 21 01. The second data set does have a base (0780 27 09 ST = 0780 27 09 Customer material.

    I only want column D to indicate where there is no base.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula to find a match with different string lengths
    By mcranda in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-09-2013, 04:34 PM
  2. [SOLVED] Vlookup, Match (Search or Find) partial string within string in a Cell
    By dluhut in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-28-2013, 12:40 PM
  3. [SOLVED] Find Exact Match Text String Using Formula
    By sweetrevelation in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-12-2012, 10:53 AM
  4. [SOLVED] Find A String Match
    By KQ3884 in forum Excel General
    Replies: 5
    Last Post: 03-19-2012, 03:45 PM
  5. Replies: 5
    Last Post: 02-29-2012, 08:51 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1