Results 1 to 7 of 7

One to many vlookup help!

Threaded View

  1. #1
    Registered User
    Join Date
    05-24-2006
    Posts
    4

    One to many vlookup help!

    Hi All

    I have two sheets, here is an example of what I am looking at:

    Sheet 1:

    Scenario:______ Number 1______Number 2______Number 3______Number X
    130
    10
    10
    33
    etc.

    Sheet 2:

    Scenario:______Number:
    1____________ 2067896512
    1____________ 2098172651
    1____________ 4258712369
    10__________ 4258097209
    10__________ 5783992762
    20__________ 1891237762
    33__________ 2349785432
    33__________ 2131452332
    33__________ 9843527232
    130_________ 4354678976
    130_________ 7836284285
    etc.

    I would like to have sheet 1 pull unique numbers from sheet 2 for the different scenarios. I have been playing with vlookup and I am not sure if I am using the correct forumla to accomplish this.

    Thanks for all your help!
    Last edited by hojeesum; 05-24-2006 at 06:22 PM.

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