Formula to show value only if a referenced cell contains a number

[roughasc]

Hi,

I'm trying to find a way to only show a value if a referenced cell contains a number.

=IFERROR(VLOOKUP(A16,ONGOING!A:K,11,0),0)

This is what i have at the moment, but the issue is that if the value returned is 0% it is automatically hidden as i need to have zero's hidden. I want to somehow show the 0% without the need to show all zeros in the sheet (if that makes sense).

The sheet i'm using the formula on is basically a summary sheet that shows data from another sheet ("ONGOING").

Any suggestions would be appreciated!

 

[Shrikant]

Try

=IFERROR(VLOOKUP(A16,ONGOING!A:K,11,0),"0%")