Get rid of #N/A error

[RodneyC]

Shouldn't this display a 0 instead of #N/A? =VLOOKUP($D48,'By Market'!$B$7:$C$63,2,0)

This =VLOOKUP($D48,'By Market'!$B$7:$C$63,2,"") causes #VALUE! to appear.

How do I need to modify it so either a 0 or a blank appear?

Thanks in advance

 

[Candyman8019]

try =iferror(VLOOKUP($D48,'By Market'!$B$7:$C$63,2,0),"")
or
=iferror(VLOOKUP($D48,'By Market'!$B$7:$C$63,2,0),0)

 

[RodneyC]

try =iferror(VLOOKUP($D48,'By Market'!$B$7:$C$63,2,0),"")
or
=iferror(VLOOKUP($D48,'By Market'!$B$7:$C$63,2,0),0)

Both work, thank you