Previous Topic Next Topic

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

Answer 1 / 1
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

Similar discussions

lava hard reset & factory reset
AVAY -
Pnr -

2 responses
Lava A1 Brand reset
Anil123 -
Ambucias -

1 response
lava gem
deepak -
HelpiOS -

1 response
trying to have the current date go into one cell (A1)
dbmich -
dbmich -

3 responses
How to create a Windows Live ID account
becca -
Bobby -

3 responses