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.