Non-Blank INDEX+MATCH without array

[qlander]

Hi All,

I was unable to find a reference to this, but I'm trying to use INDEX/MATCH to return the first non-blank result like

{=INDEX(range,MATCH(FALSE,ISBLANK(range),0))}

but due to the size of data, I can't use an array...

Any ideas?

 

[Twollaston]

Hi All,

I was unable to find a reference to this, but I'm trying to use INDEX/MATCH to return the first non-blank result like

but due to the size of data, I can't use an array...

Any ideas?

Do it like this and it will populate instantly
=MATCH(TRUE,INDEX(ISBLANK(A1:A30),0,0),0)

 

[jtakw]

I'm trying to use INDEX/MATCH to return the first non-blank result like

but due to the size of data, I can't use an array...

Hi,

If you Only need to return the relative Row number within the referenced range And there are No formulas within that range that results in Blank ( "" ), then reverse the logic by adding NOT in the formula suggested in Post # 2, like so:

=MATCH(TRUE,INDEX(NOT(ISBLANK(A1:A30)),0,0),0)

If you need to return the Actual Value in the First non-blank cell within the range ( with or without formulas producing "" )...

If the value you seek is Text Only, try this:

=INDEX(A1:A30,MATCH("?*",A1:A30,0))

If the value you seek can be Text and/or Numeric, whichever comes first, try this:

=INDEX(A1:A10,MATCH(TRUE,INDEX(A1:A30<>"",0,0),0))

All formulas entered normally.

 

[jtakw]

Oops, typo above, last formula should be:

=INDEX(A1:A30,MATCH(TRUE,INDEX(A1:A30<>"",0,0),0))