Is this possible
In the lookup Function what do the 2,1 stand for rows or something else?
"Sheeloo" wrote:
Enter this formula in B2 and copy down
=LOOKUP(2,1/C2:Z2,$C$1:$Z$1)
Change Z to the last column in your range
To hide #N/A till a date is entered use
=IF(ISNA(LOOKUP(2,1/C2:Z2,$C$1:$Z$1)),"",LOOKUP(2,1/C2:Z2,$C$1:$Z$1))
"CHerzog" wrote:
I have a work sheet with more then seven columns, each column has a cell with
a title in it. I want to know if it is possable to have a column with a
function or formula that will insert the column title if a date is entered in
that column.
I am using Excel 2003. See below for a picture of what I am looking for.
DCN1 DCN2 DCN3
Page 1 DCN1 01/02/06
Page 2 DCN3 01/02/06 05/03/07 08/09/07
Page 3 DCN2 01/02/06 05/03/07
|