You could use MATCH
Eg assuming the years (2008, 2007, etc) are numbers entered in B1 across
then in say, A20: =MATCH(2008,$1:$1,0)
will return the col number for 2008
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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.