This worked great. How can I add a lookup to this? I would like to be able to
reference a cell and find that value in the table to return the same data.

vlookup(z1,a1:y1000,INDEX(B1:F1,MATCH(TRUE,INDEX(B 2:F20,0),0)))?

"T. Valko" wrote:

Another one:

=INDEX(B1:F1,MATCH(TRUE,INDEX(B2:F20,0),0))

Format as Date

--
Biff
Microsoft Excel MVP


"MPI Planner" wrote:

I would like to be able to return the first column that has a number greater
than zero. For instance

3/2 3/9 3/16 3/23 3/30
Product A 0 0 12 0 20

How could I get a result that either returned 3/16 as the first date or
column 4 as the first instance?