Issue with Match and Index function, not picking the dates

Hello Team,

I have a Dashboard with 29 sheets and one Sheet with a name Variables has the connecting formulas. In the Sheet "CPT.Calc MTD we have Match and index formula (which is inside two columns namely Beg.Inv and End.Inv) that matches few criteria's and pulls the data from the Data sheet.

We are using a date format Month.Year (i.e., M.YYYY) to pull the data from the data sheet. The problem here for eg:
Currently we have completed 4 months (eg: Jan, Feb, Mar, and Apr) so when Beg.inv is 1.2017 then End.inv would be 2.2017.

For the date 1.2017 The formula doesn't captures the data in the column End.inv but it capture when its in Beg.inv and same thing goes with 4.2017 but its Viz a viz.

There is no problem with the dates 2.2017 and 3.2017. I'm sharing the formula's for your reference:

Beg.inv and End.inv has the same formula = =INDEX(INDIRECT(VLOOKUP(A9,VARIABLES!$G:$I,3,FALSE)),MATCH(B9,INDIRECT(VLOOKUP(A9,VARIABLES!$G:$L,4,FALSE)),0),MATCH($B$4,INDIRECT(VLOOKUP(A9,VARIABLES!$G:$L,5,FALSE)),0))


Sheet Variables (indirect Formulas to

Plant Names Range1 Range2 Range3
5101 '5101.INV'!A:ZZ '5101.INV'!A:A '5101.INV'!A2:ZZ2
5103 '5103.INV'!A:ZZ '5103.INV - CAN'!A:A '5103.INV - CAN'!A2:ZZ2


Also attaching the screenshot of the Data sheet for your reference.

Please help to resolve this problem.

Thanks & Regards,
Rajkumar H

Screen shots (images) are of little or no value so please ...

Attach a sample workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.