How can I add to a current formula to return a blank if the data set does not have a value?

[Peptide]

Hello -
How can I add to a current formula to return a blank if the data set does not have a value? Right now it returns a 0 but I need it to be blank.


=IFERROR(INDEX('Pricing Table'!$CE$3:$ET$3,MATCH(B252,'Pricing Table'!$CE$4:$ET$4,0)),"")

Thanks in advance!

 

[FDibbins]

1 way...
=if(IFERROR(INDEX('Pricing Table'!$CE$3:$ET$3,MATCH(B252,'Pricing Table'!$CE$4:$ET$4,0)),"")=0,"",IFERROR(INDEX('Pricing Table'!$CE$3:$ET$3,MATCH(B252,'Pricing Table'!$CE$4:$ET$4,0)),""))

 

[RasGhul]

You can either use;


If you have blank rows in your lookup values;

[COLOR=#333333]=if(B1="","",INDEX('Pricing Table'!$CE$3:$ET$3,MATCH(B252,'Pricing Table'!$CE$4:$ET$4,0)))[/COLOR]

or

Navigate to File/Options/Advanced/Scroll down to "Display options in this worksheet", un-tick "Show a zero in cells that have zero value"

 

[Peptide]

FDibbins,
Thank you for the formula provided - worked beautifully!