I hope someone can suggest something cleaner, but I think this will work...
If your values are in row 1:
=IF(A10,A1,INDEX(1:1,1+MATCH(0.0000000001,1:1,1)) )


"Harold Good" wrote:

How would I do a lookup in a row with 4 values:
0 4.8 3.2 0
to find the first value that is greater than 0? The answer should be 4.8 but
what would the formula look like?

Thanks,

Harold