Jasmine,

Are your numbers in sequential order? i.e. 1-20 or 20-40? If so you
can use the CHOOSE function. For example.

If the number is entered into Sheet1!A1 and you want it to produce a
number in Sheet2!A1 using the numbers 1-20 as the entered data then in
Sheet2!A1.

=CHOOSE(Sheet1!A1,10,20,30,40,50,60,70,80,90,100)

This will look at Sheet1!A1 as an index number starting at 1.
10,20,30...is the step of the index meaning if the index = 1 then 10 is
populated in
Sheet2!A1 and so on up the line 2=20,3=30. If your range of entered
values begins higher than 1 say 20-40 then.

=CHOOSE(Sheet1!A1-19,200,300,400,500,600,700.......)

Subtracting the 19 makes it recognize 20 as the first step value. You
can also incorporate an IF statement to return a blank cell if a value
entered is not in the range you are looking for.

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=505342