I have a function returning some values from a different table:


This works great for most cases, but if there's no information entered into the column in the other table, I get a 0 when I would have preferred the cell to display the same value as the other table, i.e. stay blank.

Is there any good way to do this?

Current results

enter image description here

Preferred results

enter image description here


Whenever I have this, I either use conditional formatting to hide the 0s or use an IF statement:


It returns a zero in an instance of the indexed cell being blank, so simply say if the INDEX returns blank, then assume blank, else perform the INDEX as initially required.

You can also hide 0s under

file -> options -> advanced settings -> display options for this worksheet -> show a zero in cells that have a zero value

  • Yeah, this was pretty much what I was planning on doing, I was hoping there was a way without having to repeat the formula though :-) And I wasn't aware of the third option, that may come in handy in the future, even if it isn't a perfect fit today. – eirikdaude Jan 11 at 7:59

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.