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