Assistance with Array formula

[dramos]

Hello...I was wondering if someone could assist with what I think is an array formula. I would like to write a formula that returns the non-FALSE value from three columns. I've surmised that this should be done with an array formula and not an IF statement, but am not sure how to write it out. Help screens and various searches haven't produced much help. Any assistance would be greatly appreciated. Thank you!

 

[mdusoe]

Could you please provide some sample data and your expected result?

Mike.

 

[dramos]

Absolutely, here you go:

Column A, row 2 = FALSE
Column B, row 2 = FALSE
Column C, row 2 = 2:00:01 (data is in time format)
Column D (where formula will go) = 2:00:01

So basically I'm trying to write a formula that will read columns A, B, and C and return the non-FALSE field.

 

[Domenic]

Try...

=INDEX(A2:C2,MATCH(TRUE,INDEX(ISNUMBER(A2:C2),0),0))

Note that if your range contains more than one Non-FALSE value, the formula will return the first occurrence.

Hope this helps!

 

[dramos]

That did the trick! Thank you for your assistance!

 

[barry houdini]

Perhaps you could use

=LOOKUP(9.99999999999999E+307,A2:C2)

although if there is more than one numeric value this will return the last