INDEX MATCH with Blank Cells

[Graemea]

Hi,

I want to use an INDEX MATCH formula with conditions (so an array formula) to check if the value in a particular cell is blank.

The problem with this approach seems to be that INDEX MATCH treats a blank cell as containing a zero which is not want I want.

Can someone please suggest how to use INDEX MATCH to identify if a specified cell is blank?

Thanks!

 

[Fluff]

How about

=IF(yourformula="","Blank","Not blank")

 

[Graemea]

Thanks!

 

[Fluff]

You're welcome& thanks for the feedback.