+ Reply to Thread
Results 1 to 5 of 5

Help needed in comparing text in column A & B & inserting the similar value in column c

  1. #1
    Registered User
    Join Date
    04-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2

    Help needed in comparing text in column A & B & inserting the similar value in column c

    Hi I have two columns of with a huge number of data in it.

    I need to compare data in column A to the value in Column B, & see if they match.

    if they match then put the comparison text into column C

    Please Help....

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Help needed in comparing text in column A & B & inserting the similar value in column

    Can you provide an example of what the correct match looks like?
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Help needed in comparing text in column A & B & inserting the similar value in column

    Maybe this

    In C2

    =VLOOKUP("*"&LEFT(B2,4)&"*",$A$2:$A$17,1,0)


    A
    B
    C
    1
    Keys Brands Match
    2
    1 million by paco Paco 1 million by paco
    3
    1 million by paco rabanne Angel 100 mls angel perfume
    4
    1 million paco Carolona Herrera 212 by carolina herrera
    5
    1 million parfum
    6
    100 argan oil hair
    7
    100 mls angel perfume
    8
    2 addict dior
    9
    212 by carolina herrera
    10
    212 by caroline herrera
    11
    212 carolina herera
    12
    212 carolina herrera
    13
    212 cologne
    14
    212 cologne men
    15
    212 for man
    16
    212 for men
    17
    212 fragrance
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  4. #4
    Registered User
    Join Date
    04-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Help needed in comparing text in column A & B & inserting the similar value in column

    Thanks for the reply....

  5. #5
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Help needed in comparing text in column A & B & inserting the similar value in column

    You're welcome and thank you for the feedback!

    Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).

+ 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. Replies: 1
    Last Post: 08-22-2013, 03:16 PM
  2. Formula Help Needed Please!!Comparing a cell to a column
    By jgkinder in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-28-2013, 06:15 PM
  3. Replies: 3
    Last Post: 03-09-2013, 10:23 AM
  4. Replies: 1
    Last Post: 01-09-2013, 01:47 PM
  5. Replies: 3
    Last Post: 04-07-2011, 06:45 AM

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