+ Reply to Thread
Results 1 to 3 of 3

comparing two description fields

  1. #1
    Registered User
    Join Date
    10-08-2013
    Location
    Perth
    MS-Off Ver
    Excel 2010
    Posts
    2

    comparing two description fields

    Hi
    I’m trying to do a comparison of two excel cells to see if the item description (column B) exist in the item description (column D) for each item by name.

    Each description belongs to a item name and we are trying to compare the two lists to see if they contain the same information in the description fields but in a different format.


    Column B is the user friendly version of the description whilst column D is the automated extract that is not a user friendly description. The automated extract of column D does not follow any standard and maybe as short as two words or as long as 15 words separated by a / etc


    Item name Item Description Item Name Item Description
    STCCTX2 Orange Stickers Production STCCTX2 Orange Stickers Bouncing/Orange Stickers Production/Orange Stickers/Orange Computers/orange.com
    STC-S-01 Orange Door Mats STC-S-01 Door Mats/orange.com
    STCLG001 Lime Stickers Door Mats STCLG001 Door Mats/Lime.com
    STCNTMGT01 Lime Stickers Management STCNTMGT01 Lime Stickers Management/Stickers/Lime.com
    STCVPA801 Lime Stickers Production STCVPA801 Wishy washy/Lime Stickers Production/Stickers/Lime.com
    STCWEIN001 White Door Mats STCWP001 Lime Door Mats/Stickers Production/white.com
    STCWP001 Lime Stickers Production STCWS801 Lime Stickers Production
    STCWS801 Lime Stickers Production STCWS888 Blue Stickers Production
    STCPR001 Peach Stickers Test


    Is it possible to output the result of the match (with the text “Match” or “No Match”) into column F and the name of the item into column E

    I'm not sure if this is possible but will ask anyway.
    Would it be possible that when it does the item description check that it checks for any words.
    ie row 2 column B "Orange Door Mats" equals row 2 column D "Door Mats/orange.com" as it contains all 3 words but just in a different order.

    thanks
    Paul

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: comparing two description fields

    It is difficult to determine your columns as presented.

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    10-08-2013
    Location
    Perth
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: comparing two description fields

    Hi
    thanks for showing me how to upload a sample worksheet.
    Hope this helps in explaining what we are trying to compare
    Paul
    Attached Files Attached Files

+ 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. Comparing Columns and Populating With Description
    By VyT in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-02-2013, 06:41 PM
  2. Replies: 3
    Last Post: 01-26-2010, 09:12 AM
  3. Comparing fields in 2 different spreadsheets
    By bellw in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-26-2009, 07:26 AM
  4. comparing text fields
    By jimmy474 in forum Excel General
    Replies: 3
    Last Post: 07-23-2008, 07:19 AM
  5. [SOLVED] Comparing text fields
    By [email protected] in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-28-2005, 10:05 AM

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