+ Reply to Thread
Results 1 to 5 of 5

Fill Mismatch Cells

  1. #1
    Registered User
    Join Date
    06-16-2014
    Location
    New York
    MS-Off Ver
    2010
    Posts
    2

    Fill Mismatch Cells

    Hi everyone,

    I have a table with data in 2 different columns. In the first column there are names of companies given to me by an outside source and they are labeled according to the way this outside company labels them.

    In the second coulumn, There are names of the same companies, only this time they are labeled according to the way my company labels them.

    What I need to do:

    I would like to use a formula or any excel function to find when the company name in the first column is at all different from any name in the second. If the name is different, I would like to receive an alert message, or just fill the cell red if it is easier.

    Let me know your thoughts please.

    And Thank you in advance!

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: Fill Mismatch Cells

    sample workbook pls

  3. #3
    Registered User
    Join Date
    06-16-2014
    Location
    New York
    MS-Off Ver
    2010
    Posts
    2

    Re: Fill Mismatch Cells

    I can't use the real workbook since the data is sensitive. But here is a sample with just 5 rows...The real sheet has data in over 2000 rows however.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    11-02-2012
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    564

    Re: Fill Mismatch Cells

    Is there any particular logic for naming as per your company? Do you cross check the names from a database? Or is it just human understanding that Coke should be mapped to Coca-Cola..etc? If there is no particular logic in changing the names, none of Excel functions will be able to work this way..

  5. #5
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,513

    Re: Fill Mismatch Cells

    Hi jjcucc,

    This looks like a VLookup problem/answer to me. You can put the two lists side by side and simply lookup what is given to what you have. See.
    http://www.contextures.com/xlFunctions02.html or
    http://www.timeatlas.com/5_minute_ti...l#.U58cqeBOVDw
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to color-fill blank cells, then once data is entered cell is no-fill
    By hatemail13 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-28-2013, 07:57 PM
  2. Replies: 1
    Last Post: 09-07-2011, 05:57 PM
  3. type mismatch error when deleting cells
    By thigham2000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2008, 05:04 PM
  4. [SOLVED] using functions to compare multiple columns for mismatch of cells
    By MDIAZ451 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-12-2006, 10:50 PM
  5. [SOLVED] create a fill in template to tab to fill in cells
    By Excel-erator in forum Excel General
    Replies: 2
    Last Post: 07-06-2005, 05:05 PM

Tags for this Thread

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