| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Columns
I have a work sheet with 6 columns the headers of the columns are A=Class
Codes,B-F are years 2008,2007,2006etc. can i have excell put a value in a cell as to the column number for the years example for 2008 column 2 for 2007 column 3 and so on. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Columns
Where does the value originate and how should Excel know where to put it?
Some more clarity needed for this responder. Gord Dibben MS Excel MVP On Mon, 31 Mar 2008 16:51:43 -0700, 904allen wrote: I have a work sheet with 6 columns the headers of the columns are A=Class Codes,B-F are years 2008,2007,2006etc. can i have excell put a value in a cell as to the column number for the years example for 2008 column 2 for 2007 column 3 and so on. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Columns
1)=IF(C9="","",IF(DATE(YEAR(C9),12,31)F$6,F$6,DAT E(YEAR(C9),
12,31))) orignating formula My Vlookup then looks at this formula 2)=IF(D9="","",""&TEXT(D9,"yyyy")) this is my Vlookup formula =HLOOKUP('Penalty Calculation Worksheet'!B9,A10:B14,2) B9 is the second formula "Gord Dibben" wrote: Where does the value originate and how should Excel know where to put it? Some more clarity needed for this responder. Gord Dibben MS Excel MVP On Mon, 31 Mar 2008 16:51:43 -0700, 904allen wrote: I have a work sheet with 6 columns the headers of the columns are A=Class Codes,B-F are years 2008,2007,2006etc. can i have excell put a value in a cell as to the column number for the years example for 2008 column 2 for 2007 column 3 and so on. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| Create stacked columns chart but with 2 columns for each x axis? | Charts and Charting in Excel | |||
| Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
