A1 draws amount from other cells by live date. [Closed]

Report
Posts
1
Registration date
Thursday February 18, 2016
Status
Member
Last seen
February 18, 2016
-
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
-
I'm stumped.
I need the value in cell A1 to change automatically the first of each month.
Column A2:A13 has dates for the first day of Jan through Dec. Column B2:B13 has hard different numbers for monetary values that change each month (the amount of interest to charge).
I need for cell A1 to automatically draw the hard numbers in B the 1st of each live month.
Hope you can help.

1 reply

Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
There might be a more efficient way but this works.

=VLOOKUP(INDEX($A$2:$A$13,MATCH(DATE(YEAR(NOW()),MONTH(NOW()),1),$A$2:$A$13,0)),$A$2:$B$13,2,FALSE)


Sample Data used:
54	
1/1/2016 12
2/1/2016 54
3/1/2016 78
4/1/2016 234
5/1/2016 768
6/1/2016 34
7/1/2016 2
8/1/2016 423
9/1/2016 67
10/1/2016 2
11/1/2016 12
12/1/2016 312
Posts
122
Registration date
Tuesday August 31, 2010
Status
Contributor
Last seen
June 20, 2016
24
I was right, didn't need all that other junk in there:
This works just as well.

=VLOOKUP(DATE(YEAR(NOW()),MONTH(NOW()),1),$A$2:$B$13,2,FALSE)


Don't know what I was thinking before :)