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!