lookup > 0

H

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
 
B

Biff

Hi!

Try this:

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

=INDEX(A4:D4,MATCH(TRUE,A4:D4>0,0))

A little more robust:

=INDEX(A4:D4,MATCH(1,(ISNUMBER(A4:D4))*(A4:D4>0),0))

Biff
 
Top