Hi all,

I'm trying to get this formula to return the first non-blank cell: =+INDEX($A$1:$E$10,MATCH($A13,$A$1:$A$10,0),MATCH(B$12,$A$1:$E$1,0))

I have tried e.g.
=+INDEX($A$1:$E$10,MATCH($A14,$A$1:$A$10,0),MATCH(B$12,$A$1:$E$1,0),MATCH(TRUE,$A$1:$E$10<>"",0))

But that returns #NA.

The array contains formulas, and I want to get the first match where the formula has returned a value.

Thank you in advance!