One to many problem?
 

Hi All

I posted this on the Excel Worksheet function forum, but I think it
might require some VBA help.

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!


--
hojeesum
------------------------------------------------------------------------
hojeesum's Profile: http://www.excelforum.com/member.php...o&userid=34770
View this thread: http://www.excelforum.com/showthread...hreadid=545338