We are trying to create a worksheet where when a user enters a particular
number it puts a different number on the second sheet. Was trying to use
nested If statements to do this. However, we have more than 20 things that
need to be looked at. Is there another way to do this? Thanks!

if you can make a table of the values (one column with the value entered
and another with the response to that value) you can use a vlookup. This
can search the first column and return the value in the second.

You will find plenty of advice and examples of vlookup in help and in
previous posts in this forum

Hope this helps you on your way.


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=505342

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