Results 1 to 5 of 5

Partial Match List

Threaded View

  1. #1
    Registered User
    Join Date
    03-23-2012
    Location
    San Bruno, CA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Partial Match List

    First time posting to the forum. I've read through several similar posts and have ran into a corner. I'm attempting to match two lists with partial match company names.

    My goal is to match up Column E with Column B in order to identify duplicate companies.

    Here's what I've tried

    I've trimmed the first word in Column e's name into Column D. I'm now trying to find Column D in Column B.

    =IF(ISERROR(MATCH(D1,$B$1:$B$5000,0)), A1,"")

    The trouble seems to be in my result. It will always just give me the result from row a. In trying the match the two lists, I'd like to learn how to have it find D in B and give me either the result it finds in B or the result from column A next to the match in column B. I've attached the sheet.

    Help from someone more experienced with this type of function would be tremendously helpful.

    Thank you!
    Attached Files Attached Files
    Last edited by bror; 03-23-2012 at 07:54 PM.

Thread Information

Users Browsing this Thread

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

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