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!
Bookmarks