Trying to convert a #VALUE! an/or #CALC! error into a blank cell

[BigPapaMurf]

Long story short, these 2 formulas work perfectly when it finds the qualified data, but if there is no matching data, I receive a #VALUE! or #CALC! error in the first cell

#VALUE! error

=SORT(CHOOSECOLS(FILTER(Bills!$B$5:$J$49,(Bills!$C$5:$C$49=Bills!$L$30)*(Bills!$I$5:$I$49>0),""),1,8,9),3)

#CALC! error

=SORT(CHOOSECOLS(FILTER(Bills!$B$5:$J$49,(Bills!$C$5:$C$49=Bills!$L$30)*(Bills!$I$5:$I$49>0)),1,8,9),3)

How can I get it to return a blank cell? I've tried adding a IFERROR function in a few places but I'm not getting the result I'm looking for. I'm probably putting IFERROR in the wrong place.

[Sam Capricci]

IFERROR( usually goes in front and ,0) at the end, is that what you tried?
=IFERROR(your formula),0)

[BigPapaMurf]

Sam, I tried a variation of that, I don't remember where, and it didn't work, but I got it working now, thanks.

TMS

I believe your first example is going to work for me, but since I don't want it to return any value, I changed the 0 at the end to double quotes. I think this is exactly what I needed. Thanks.

I replaced the last 0 you added with the double quotes at the end and removed the pair I already had in there.

This one worked...

=IFERROR(SORT(CHOOSECOLS(FILTER(Bills!$B$5:$J$49,(Bills!$C$5:$C$49=Bills!$L$30)*(Bills!$I$5:$I$49>0)),1,8,9),3),"")

[TMS]

I tried a variotion of that, I don't remember where, and it didn't work, but I got it working now, thanks.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon (Next to Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[BigPapaMurf]

=IFERROR(SORT(CHOOSECOLS(FILTER(Bills!$B$5:$J$49,(Bills!$C$5:$C$49=Bills!$L$30)*(Bills!$I$5:$I$49>0)),1,8,9),3),"")

This one worked ^ The 2 pairs of double quotes was redundant.

[TMS]

Maybe this:

=IFERROR(SORT(CHOOSECOLS(FILTER(Bills!$B$5:$J$49,(Bills!$C$5:$C$49=Bills!$L$30)*(Bills!$I$5:$I$49>0),""),1,8,9),3),0)

Or this:

=IFERROR(SORT(CHOOSECOLS(FILTER(Bills!$B$5:$J$49,(Bills!$C$5:$C$49=Bills!$L$30)*(Bills!$I$5:$I$49>0),""),1,8,9),3),{0,0,0})

[TMS]

Thanks for the rep.