On Mon, 18 Aug 2008 13:23:01 -0700, travelinman
wrote:

I am looking for a way to have Cell C1 look at A1 and determine by the text
to add 1 or 2 to the date in B1. A1 may contain up to 10 Statements. Four of
the statements will require adding 1 to B1 and 6 of the statements will
require adding 2 to B1. Can this be done and if yes I need help. Thanks.


Cell A1 Cell B1
Cell C1
<Report Request 18-Aug <B1 +1


Try this formula in cell C1:

=B1+LOOKUP(A1,{0,"Statement 1","Statement 2","Statement 3"},{0,1,2,1})

In this example there are only three statements, you can easily add
more statments.
The order of the statements is not important, just make sure that the
order of the numbers in the result vector corresponds to the
statements.

Hope this helps / Lars-Åke