Columns

[904allen]

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.

 

[Gord Dibben]

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

 

[904allen]

Thanks Guys I got it figured out. I now have another problem I'm attempting
to do a Vlookup formula. I used this formula with a fixed cell before and it
works, I'm now attempting to use a cell that has a formula that changes the
year this is the look_up value. i can't get excel to read the value and not
the formula. this is the last thing i need to get this project running.
Thanks Allen

 

[904allen]

1)=IF(C9="","",IF(DATE(YEAR(C9),12,31)>F$6,F$6,DATE(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