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
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Feb 23, 2016 at 04:21 PM
Related:
- A1 draws amount from other cells by live date.
- Tiktok live studio download - Download - Video recording and streaming
- Windows live mail download - Download - Email
- Windows live photo gallery - Download - Image viewing and management
- Pokemon tcg live download pc - Download - Strategy
- Insert the current date and time in cell a1 ✓ - Excel Forum
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
Feb 23, 2016 at 10:54 AM
There might be a more efficient way but this works.
Sample Data used:
=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
Feb 23, 2016 at 04:21 PM
This works just as well.
Don't know what I was thinking before :)