Results 1 to 8 of 8

Pulling in a subset of a larger data set

Threaded View

  1. #1
    Registered User
    Join Date
    03-18-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    17

    Pulling in a subset of a larger data set

    In Sheet1, I have a list of box numbers in Column A and a list of serial numbers in Column B:

    1 100001
    1 100002
    1 100003
    2 100004
    2 100005
    3 100006
    3 100007
    3 100008
    etc...

    In Sheet2 I want to input a list of box numbers in Column A:

    1
    2
    3
    etc...

    I need an output of all the serial numbers from boxes listed in Sheet2 Column A into Sheet3 Column A. For example, inputting the following in Sheet2 Column A:

    1
    3

    would produce the following in Sheet3 Column A

    100001
    100002
    100003
    100006
    100007
    100008


    Thanks for your time!
    Last edited by JBeaucaire; 03-19-2013 at 12:04 AM. Reason: Don't guess at the answer in your title. Changed the title to your actual topic, as per the Forum Rules.

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