It's still not clear (to me!) what you want to do.

Based on the first post of this thread it sounds to me like you're just
duplicating you data but in a different order. That's why I suggested just
sorting it or making a copy and sorting that copy.

If you have duplicate numbers and you want to do a lookup based on a number
it can be complicated. I assume if you enter the number 1 then you want all
the info for *every instance* of 1:

6...Bob...Ohio
1...Joe...California
1...Sam...New York
7...Sue...Georgia.

See if this sample file is what you had in mind:

DeleteMe.xls 16kb

http://cjoint.com/?knxBzcL3yL

Select a number from the drop down and the list populates based on that
selection.

The formulas used to do this are array formulas. Array formulas need to be
entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER).

--
Biff
Microsoft Excel MVP


"zoomzoom632" wrote in message
...
Yeah, that's basically what I mean, but I forgot to include something in
my
previous message. The list is in alphabetical order by the name. so your
list would be...

6...Bob...Ohio
1...Joe...California
1...Sam...New York
7...Sue...Georgia.

Also, please disreguard my message, "Number Order"

Thanks and sorry.

"T. Valko" wrote:

Now, there's a curve ball, Sheet one has the numbers repeating.

Do you mean that there are different names with the same number?

1...Joe...California
7...Sue...Georgia
6...Bob...Ohio
1...Sam...New York

Column 1: I want to be able to enter a number.

So, if you enter number 1 which line of info do you want?

--
Biff
Microsoft Excel MVP


"zoomzoom632" wrote in message
...
There is a slight change here.

Sheet One lists:
Column 1: A number
Column 2: A person's Name
Column 3: The place they are from.

On Sheet two,
Column 1: I want to be able to enter a number.
Column 2: Based on the number in column 1, sheet 2 that I entered, the
person's name that is next to that number on sheet one will apear.
Column 3: Based on the number in column 1, sheet 2 that I entered, the
place
they are from, that is next to that number on sheet one will apear.

Now, there's a curve ball, Sheet one has the numbers repeating. So I
want
to makesure the correct number matches the correct name, then I'll base
the
place they are from off of the name which can only appear once in the
list.

Thanks to several responces, I managed to create the page worksheet to
interact like I listed below.

"zoomzoom632" wrote:

Here's the Senario,

Sheet One Contain the Results of a Race:
Column A: Racers Name (in ABC order)
Column B: Their Hometown
Column C: Their Time
Column D: Their Heat Number

On Sheet 2 I want to have the spreadsheet seach for the proper
infomation
from sheet 1.
The Colums are the same, and here, the row numbers represent the place
number.

In Column C, I want it to find the lowest time first, then in the 2nd
row,
find the 2nd lowest time, ect.

In the other three column, I want it to match the data listed next to
the
time from sheet one, in their appropriate columns.

I hope you can figure out what I mean.

Thank you.