Vlookup & summing multiple columns.

Hi all

I am trying to do a vlookup and sum multiple columns #s based on a moving target month, comparing them to the current year.
IE currently August, so this years YTD totals against last years july and august totals summed.

Hope this make sense. Attached is a dummy spreadsheet to help me work this out.

Thanks