Previous Topic Next Topic

A1 draws amount from other cells by live date.

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

Réponse 1 / 1
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 26
23 Feb 2016 à 10:54
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
RayH Posts 122 Registration date Tuesday 31 August 2010 Status Contributor Last seen 20 June 2016 26
23 Feb 2016 à 16:21
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 :)

Similar discussions

lava hard reset & factory reset
AVAY -
Har -

3 responses
Lava A1 Brand reset
Anil123 -
Ambucias -

1 response
How to format Lava mobile?
Akum -
Dushyant -

22 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

1 response
replay tiktok lives
chazza88 -
chazza88 -

2 responses