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

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

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

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