LOOKUP Function Replacement

Hi,

Does it support array formulas?

If so:

If your entries in column A are numerical:

=INDEX($A$38:$A$92,MATCH(10^10,IF(($C$38:$C$92>=$I10)*($E$38:$E$92>=$I10),A$38:A$92)))

If your entries in column A are text:

=INDEX($A$38:$A$92,MATCH(REPT("z",255),IF(($C$38:$C$92>=$I10)*($E$38:$E$92>=$I10),A$38:A$92)))

Regards