Are you sure the LOOKUP() function is returning the result you intended?

Try the lookup on it's own to see what is returned.

the -1 is just to offset the matched column back 1 to sum to previous month.

If still an issue, post sample with issue.