I need a VLOOKUP formula that to find August month in the column and to add
sum only August month in a sheet

In my formula B2 is the month I request MID is sheet I request to find
august month and add sum only August

=VLOOKUP(B2,MTD!A4:AZ400,2,FALSE)