Biff,

I see that Sean got it to work by putting in some value but, when I
duplicate your formula with my cells, each response (answer) comes up Dec-25
(which is the last column). What did I do wrong? And, what does the 10^10
do?

Thanks again. You guys Rock!!

Ron

"T. Valko" wrote:

Try something like this:

D1:J1 = date headers

=IF(C2=1,LOOKUP(10^10,D2:J2,D$1:J$1),"")

Format as DATE

Biff

"ronnomad" wrote in message
...
I have data that is about 2000 rows and 55 columns. 52 of the columms are
headed with a week starting date. The other columns have product names,
number and number of times ordered (this number is attained by counting
the
times a quantity appears in a dated column). The 52 dated columns have
the
quantity ordered but each items is not ordered every week. What I would
like
to do is:

For the items that have been ordered only once, find the date in the
heading
and place that date in a column beside the product name.

Is there a way to write a formula (or macro) that would basically say,
"if
the quantity in columm C (the number of times ordered) is equal to 1, look
across the dated columns until a value greater than zero is found and then
copy the date at the head of that column into the cell where the formula
is".

Thanks & Happy New Year

Ron R