Finding A Blank With The Match Function

[MikeG]

I want to use MATCH to find the first occurance of a blank cell in a range.

I've tried MATCH("",A1:A50,0)

But it does not work.

Can anyone help?

Thanks,

MikeG

 

[Marcelo Branco]

Maybe this

=MATCH(TRUE,INDEX(ISBLANK(A1:A50),0),0)

HTH

M.

 

[Marcelo Branco]

Or if you have formulas in the Range(A1:A50) returning ""

=MATCH(TRUE,INDEX(A1:A50="",0),0)

M.

 

[MikeG]

Or if you have formulas in the Range(A1:A50) returning ""

=MATCH(TRUE,INDEX(A1:A50="",0),0)

M.

Thanks Marcelo - just what I needed!

 

[Scott Huish]

Shouldn't need INDEX.

=MATCH(TRUE,A1:A50="",0)

Confirm with CTRL-SHIFT-ENTER rather than just Enter.

 

[Marcelo Branco]

Thanks Marcelo - just what I needed!

You are welcome and tks for the feedback

M.
ps: i've used INDEX because sometimes one can forget to confirm with Ctrl+Shift+Enter