Try this:

=INDEX(A1:G1,MATCH(1,INDEX((A2:G20)*(ISNUMBER(A2: G2)),),))

Just press ENTER



"Rae" wrote:

This is probably easy, but I just can't figure it out...

Here is an example of what I'm trying to accomplish:
(Data Sheet)
A B C D E F G
1 Date 8/25 8/26 8/27 8/28 8/29 8/30
2 Fcst 0 0 0 0 250 500

(Summary Sheet)
A B
1 SUMMARY
2 Qty of First Req 250 (this is what i'm having trouble with... i need it
to pull the first non-zero value from Data Sheet, Row 2, Columns A thru G)

3 Date of First Req 8/29 (Ideally, i would like it to also pull the
corresponding Date of first non-zero value)

Thanks for the help!