Earl Kiosterud wrote:

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.

My data will remain static, so the solution is just fine. Thanks for replying.

--