|
|
#2
04-29-2014, 02:16 PM
|
|||
|
|||
Not knowing much about the structure of your sheet other than what I've been able to decipher from your post, here's my first stab at it...
If the headings of your columns (i.e. row 1) are dates, you can do an HLOOKUP: =HLOOKUP(DATE(YEAR(NOW()),MONTH(NOW())-1,1),C1:N9,9,FALSE) Basically, the HLOOKUP looks for the date that is one month previous to now. Of course, this won't work so well when it's January and it looks for a month=0. Attached is test.xlsx illustrating how this is done. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Copying data from one cell to another where condition is third cell | fairyca | Excel | 4 | 03-30-2014 08:22 AM |
| Changing Cell address within a formula | vermont_past | Excel | 12 | 09-21-2012 12:15 PM |
| Copying part of a cell to a new cell | paulw793 | Excel | 7 | 01-27-2012 10:46 AM |
 Copying data from one cell to another automatically
|
mrphilk | Excel | 4 | 06-10-2010 11:52 PM |
|
Code for Changing Cell Backgrounds
|
leroytrolley | Excel | 2 | 12-05-2008 02:05 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode