Thread: lookup 0
View Single Post
  #1   Report Post  
Harold Good
 
Posts: n/a
Default lookup 0

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