lookup a value "greater than" 0

[Harold Good]

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

 

[Guest]

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

 

[Harold Good]

Thanks for your help bpelzter. Biff did suggest this one, both yours and his
work well.

Thanks for your help.

Harold
============
Try this:

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=INDEX(A44,MATCH(TRUE,A44>0,0))

A little more robust:

=INDEX(A44,MATCH(1,(ISNUMBER(A44))*(A44>0),0))

Biff
=======================