Syntax error

[hektisk]

I have the following code for a monthly report, which works as intended:

Please Login or Register  to view this content.

$C$3 represents the month of the report, in text form (January, February, etc.). I would like to add another column with data from the month prior. So, if $C$3 is February, I want the match lookup_value in the new string to be January. The following formula returns 'January' if the value in C3 is February:

Please Login or Register  to view this content.

I've tried inserting this formula in the following code:

Please Login or Register  to view this content.

However, I'm now getting a syntax error. I'm thinking that it has to do with the quotations around "mmmm", but I'm not entirely certain. If this is the problem, how do I work around this? Any other ideas?

Thanks.

Adam

[martindwilson]

try ""mmmm""

[hektisk]

How wonderfully simple of a solution. Thank you