Excel ISERROR question

Hi Experts:
I have this formula on cells in my spreadsheet:
=IF($A$1="ALL",Data!A4,IF(ISERROR(FIND($A$1,Data!D4)),"",Data!A4))

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.
snix123Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
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 :)
0
 
patrickabCommented:
Try:

=IF($A$1<>Data!A4,"",IF(ISERROR(FIND($A$1,Data!D4)),"",Data!A4))
0
 
snix123Author Commented:
I still get a 'zero'.  Researching this further...thanks for your help, though.
0
 
TonyWongCommented:
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.

Cheers,
Tony
0
 
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?
0
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.