Help in using function supported by an apple app

I need help please rewriting the below formula using only the functions available at the following link:

http://support.dataviz.com/support_i...l#dtg_iphone21

=INDEX(A:A,INDEX(MAX((C38:C92>=I10)*(E38:E92>=I10)*ROW(A38:A92)),0))

Don't know if this will work on that app, but it's an alternate to the formula you posted.

=LOOKUP(2,1/((C38:C92>=I10)*(E38:E92>=I10)),A38:A92)

Thank you, but the LOOKUP function is not part of the listed functions in the above link, therefore it is not supported by my app, I need please supported functions only to be used to rewrite the formula.

Regards,

Try

=INDEX(A38:A92,MATCH(2,1/((C38:C92>=I10)*(E38:E92>=I10)),1))

This is an array formula that must be entered with CTRL + SHIFT + ENTER

I am sorry, but as you can tell from the link table, array formulas are not supported!!

Then I'm afraid it most likely can't be done in a single formula...
You'll need a helper column to do an AND function..
Say in column D
D38: =IF(AND(C38>I$10,E38>I$10),1,"")
Fill down to D92

Then you can use
=INDEX(A38:A92,MATCH(2,D38:D92))

And for me, Many thanks

You're welcome.