Excel ISERROR question

Hi Experts:
I have this formula on cells in my spreadsheet:

The spreadsheet contains a value in A1 which can vary.  The data as you can see comes from another spreadsheet.  If the A1 value does not match the Data spreadsheet D4 cell, I want a blank or null.  Now I am getting zeros when there is no match.

I hope this makes sense.

Thank you.
Who is Participating?

Improve company productivity with a Business Account.Sign Up

TonyWongConnect With a Mentor Commented:
Still, if the formula in the cell is returning a '0' value (and it's supposed to be that as a result) then what I suggested should stop displaying the zeroes.

snix123, it's up to you if you want to close it as you're the OP :)

snix123Author Commented:
I still get a 'zero'.  Researching this further...thanks for your help, though.
Hi there, not sure if this is resolved yet but you may want to check out your settings.

Depending on what version of Excel you have, go to File->Options->Advanced.
In the dialog box that pops up, go to 'Show zero in cells that have a zero value' and uncheck it.

snix123Author Commented:
Thank you for your input.  The problem was that the cells were never blank since they had a formula in them!  Have rescoped how things were happening and it seems o.k. now...can we close this one?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.