Vlookup formula to take systems month and date and search in sheet1 for same month and year and retrive adjacent cell value

H

hasansha

New Member
Joined
Mar 2, 2018
Messages
4
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
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Sort by date Sort by votes
Hi. Try one of these:

=VLOOKUP(DATE(YEAR(TODAY()),MONTH(TODAY()),1),Sheet1!B:F,5,0)
=VLOOKUP(TEXT(TODAY(),"mmmm-yyyy"),Sheet1!B:F,5,0)
 
Last edited:
Upvote 0
Below is sheet



A
S.No
B
Month
C
EMI
D
Interest
E
Principle
F
Loan Outstanding
1April-20161058957374852345148
2May-20161058956584932340216
3June-20161058955775012335204
4July-20161058954955095330109
5August-20161058954115178324931
6September-20161058953265263319668
7October-20161058952405349314319
8November-20161058951525437308882
9December-20161058950635526303356
10January-20171058949735617297739
11February-20171058948805709292030
12March-20171058947875802286228
13April-20171058946925897280330
14May-20171058945955994274336
15June-20171058944976092268244
16July-20171058943976192262052
17August-20171058942956294255758
18September-20171058941926397249361
19October-20171058940876502242859
20November-20171058939816608236251
21December-20171058938736717229534
22January-20181058937626827222708
23February-20181058936516939215769
24March-20181058935377052208717
25April-20181058934217168201549
26May-20181058933047285194263
27June-20181058931847405186858
28July-20181058930637526179332
29August-20181058929407650171682
30September-20181058928147775163907
31October-20181058926877902156005
32November-20181058925578032147973
33December-20181058924268164139809
34January-20191058922928297131512
35February-20191058921568433123078
36March-20191058920178572114507
37April-20191058918778712105794
38May-2019105891734885596939
39June-2019105891589900087939
40July-2019105891441914878791
41August-2019105891292929869494
42September-2019105891139945060044
43October-201910589984960550439
44November-201910589827976240676
45December-201910589667992230754
46January-2020105895041008520669
47February-2020105893391025010418
48March-202010589171104180

<colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:3766;width:77pt" width="103"> <col style="width:48pt" width="64" span="3"> <col style="mso-width-source:userset;mso-width-alt:4425;width:91pt" width="121"> </colgroup><tbody>
</tbody>
 
Upvote 0
Click in the cell showing March-2018. What does the formula bar say?
 
Upvote 0
Cross posted https://www.excelguru.ca/forums/showthread.php?8839-Lookup-Question

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,215,265
Messages
6,123,961
Members
449,135
Latest member
jcschafer209

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top