Combining Formulas (1 Viewer)

I have 2 formulas that I need to combine for a report that I am creating, the first one pull the name of the previous month:


The second one is a dlookup, Where I am trying to pull a value from the previous month.

Unsure if I am going about this the wrong way. I do not wish to have the query be the data source for this report.

Any guidance how to proceed, or where I can find some additional information would be greatly appreciated,

I was able to figure this out, and, for anyone who faces the same problem, this is the answer,

I think you might be going about this the wrong way. You have columns named after months? If so, that is incorrect. Instead, you should have the month name be a value in the column.