+ Reply to Thread
Results 1 to 2 of 2

Compare text in two different columns in Excel then print text

  1. #1
    Registered User
    Join Date
    04-05-2010
    Location
    bellevue, wa
    MS-Off Ver
    Excel 2007
    Posts
    3

    Compare text in two different columns in Excel then print text

    I need to compare a text list in Column A in Sheet #1 to a text list in Column C in Sheet #2 and then print the resulting text it found in Column B in Sheet #1.

    For example:

    Sheet #1

    A | B
    ------------------+--------------------
    microsoft | rr@microsoft.com
    jimc | er@microsoft.com
    gmail | don@gmail.com
    hotmail |

    Sheet #2

    C
    -------------------
    rr@microsoft.com
    don@hotmail.com
    don@gmail.com
    er@microsoft.com
    empty@mail.com

  2. #2
    Forum Expert davegugg's Avatar
    Join Date
    12-18-2008
    Location
    WI, US
    MS-Off Ver
    2010
    Posts
    1,884

    Re: Compare text in two different columns in Excel then print text

    I don't see from your example how any of the text in column A of sheet 1 would be found in column C of sheet 2.
    However, the vlookup() function can do the process you are speaking of very easily. Have a look at the help for it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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