Formula shows "0"

[royhern]

Hey team, have this formula that shows the number "0" while in the data tab no number shows...how can i change the formula to show a blank cell when no number shows on the data tab.

=IF(ISERROR(VLOOKUP($H11,Data,I11,FALSE)),"",VLOOKUP($H11,Data,I11,FALSE))

Thanks, Roy

 

[konew1]

If you are certian it should never return a zero you coud try
=IF(ISERROR(VLOOKUP($H11,Data,I11,FALSE)),"",if(VLOOKUP($H11,Data,I11,FALSE))=0,"",VLOOKUP($H11,Data,I11,FALSE))

 

[al_b_cnu]

Alternatively, if you're expecting text or an integer to be returned, you could custom format the cells with '#'