Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMAT
Hi,
I have the table below for 2008/2009. Now, in another sheet in cell A1 I have the "Year" and in cell B1 I have the "Period". I need a formula to find the "Actual" value from the table below for the Period in cell B1. My issue is that in my formula I may need let's say the value in cell B1 but 4 prior periods and as you can see they may fall into the previous year (i.e. A1=2009, B1=2; I need the actual value 4 prior periods or the value for period 11, 2008). Any ideas? Thanks. Tony. Year Period Actual 2008 1 $0.0000 2008 2 $0.0000 2008 3 $0.1500 2008 4 $0.2800 2008 5 $0.1500 2008 6 $0.2800 2008 7 $0.3000 2008 8 $0.4800 2008 9 $0.3600 2008 10 $0.0000 2008 11 $0.0000 2008 12 $0.0000 2009 1 $0.4200 2009 2 $0.4800 2009 3 $0.4800 2009 4 $0.5000 2009 5 $0.4800 2009 6 $0.4800 2009 7 2009 8 2009 9 2009 10 2009 11 2009 12 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
how to format excel format to text format with separator "|" in s. | New Users to Excel |