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.