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!


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