lookup 0
You're welcome. Thanks for the feedback!
Biff
"Harold Good" wrote in message
...
Wow, works great, thanks so much!
Harold
===================
"Biff" wrote in message
...
Hi!
Try this:
Entered as an array using the key combo of CTRL,SHIFT,ENTER:
=INDEX(A4:D4,MATCH(TRUE,A4:D40,0))
A little more robust:
=INDEX(A4:D4,MATCH(1,(ISNUMBER(A4:D4))*(A4:D40),0 ))
Biff
"Harold Good" wrote in message
...
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
|