Hi
I have a excel sheet1 and Sheet2 in sheet 1 i have month, interest, principal and outstanding columns. i want to right a formula in sheet2 where it will take the todays month and year and search for sheet1 column month and return the outstanding column value. Please help me out with the formula. Below is my sheet and i have tried this formula
=VLOOKUP(TEXT(TODAY(),"mmmm")&"-"&YEAR(TODAY()),Sheet1!A1:F49,6,TRUE)
S.No Month EMI Interest Principle Loan Outstanding
1 April-2016 10589 5737 4852 345148
2 May-2016 10589 5658 4932 340216
3 June-2016 10589 5577 5012 335204
4 July-2016 10589 5495 5095 330109
5 August-2016 10589 5411 5178 324931
6 September-2016 10589 5326 5263 319668
7 October-2016 10589 5240 5349 314319
8 November-2016 10589 5152 5437 308882
9 December-2016 10589 5063 5526 303356
I have a excel sheet1 and Sheet2 in sheet 1 i have month, interest, principal and outstanding columns. i want to right a formula in sheet2 where it will take the todays month and year and search for sheet1 column month and return the outstanding column value. Please help me out with the formula. Below is my sheet and i have tried this formula
=VLOOKUP(TEXT(TODAY(),"mmmm")&"-"&YEAR(TODAY()),Sheet1!A1:F49,6,TRUE)
S.No Month EMI Interest Principle Loan Outstanding
1 April-2016 10589 5737 4852 345148
2 May-2016 10589 5658 4932 340216
3 June-2016 10589 5577 5012 335204
4 July-2016 10589 5495 5095 330109
5 August-2016 10589 5411 5178 324931
6 September-2016 10589 5326 5263 319668
7 October-2016 10589 5240 5349 314319
8 November-2016 10589 5152 5437 308882
9 December-2016 10589 5063 5526 303356