+ Reply to Thread
Results 1 to 4 of 4

finding a match in a list

  1. #1
    Registered User
    Join Date
    05-17-2011
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2007
    Posts
    7

    finding a match in a list

    I need help with finding a match in a list.

    I have a spreadsheet that has 50k rows of data. In one of the columns there is a list of comma delimited numbers. i.e.

    A1: words B1: 1,2,4,34,37,2343
    B2: words B2: 3,22,564,223,2344

    on a seperate sheet I have these the numbers that column B would be referencing in a list with additional details. i.e.

    A1: 1 B1: detail1 C1: detail2
    A2: 2 B2: detail1 C2: detail2

    What I need to do is add a column to the first sheet showing if any of the numbers in Column B match with any of the numbers in the second sheet. i.e.

    Do 1, 2, 4, 34, 37, or 2343 appear in the column A of the second sheet?

    I have already created a sheet that has the comma delimited numbers expanded by "text to columns" in an attempt to create an array to use, but I'm not sure if that is going to make it easier or not.
    Attached Files Attached Files
    Last edited by erikwvb; 05-17-2011 at 04:18 PM.

  2. #2
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: finding a match in a list

    can you upload a sample which demonstrates what you want?
    Blake 7

    If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

    If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.

    http://failblog.org/

  3. #3
    Registered User
    Join Date
    05-17-2011
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: finding a match in a list

    uploaded
    hope that helps

  4. #4
    Registered User
    Join Date
    05-17-2011
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: finding a match in a list

    Anybody have any ideas on this?

+ Reply to Thread

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