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