determining a set value from multiple ranges?

[H_2008]

I am trying set up my spreadsheet so that when a number is put into one column. The next column is filled with a number that will correspond to the other number specified from a range of data.

IE.

Distance Sheet no.

55

68

93

135

186



So in the sheet No. column I want it to read the number in the Distance and put in the Corresponding sheet number.

So if:

Sheet 1 is : a distance of 1 though 20
Sheet 2 is : a distance of 20 though 40
Sheet 3 is : a distance of 40 though 60
Sheet 4 is : a distance of 60 though 80
Sheet 5 is : a distance of 80 though 100
Sheet 6 is : a distance of 100 though 120
Sheet 7 is : a distance of 120 though 140
Sheet 8 is : a distance of 140 though 160
Sheet 9 is : a distance of 160 though 180
Sheet 10 is : a distance of 180 though 200

How can this be automated without writing a ton of nested if statements.

This is an example but in reality I have 29 "sheets" with different ranges to separate.

If anyone can help that would be great!

[shg]

I don't understand ...

[H_2008]

It has been figured out!

using the lookup function I can set the range of minimums and the answer range I want to appear for each!