Saxman,

Glad to hear it. Thanks for the feedback.

The VLOOKUP solutions that have been offered would certainly be the way to go if you had a
lot of values, and if you do get more, you should probably switch to that solution. The
IF/AND/CHOOSE solution I offered would start to get messy and difficult to update when
things change, whereas the table with VLOOKUP is a clean way of handling it.
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Saxman" wrote in message
...
Earl Kiosterud wrote:

=IF(AND(A3=1,A3<=9),CHOOSE(A3,11,8,7,0,0,0,0,0,0) ,0)

This works fine by pasting into B1,B2,B3 and amending the function.

Thanks.

--