A1 draws amount from other cells by live date.

Closed
M.Morey Posts 1 Registration date Thursday February 18, 2016 Status Member Last seen February 18, 2016 - Feb 18, 2016 at 08:48 PM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Feb 23, 2016 at 04:21 PM
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.
Related:

1 response

RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Feb 23, 2016 at 10:54 AM
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
0
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Feb 23, 2016 at 04:21 PM
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 :)
0