Using VLookup and format the #N/A result

[rvtrails]

I would like to format an #N/A result to a blank cell or with a 0 when
instead of the #N/A.

Can anyone assist in how to accomplish that?
Thanks!
Linda

 

[Niek Otten]

=if(isna(YourFormula),"",YourFormula)
or, in Excel2007 and newer:
=iferror(YourFormula,"")

 

[rvtrails]

Perfect!! Thank you!

=if(isna(YourFormula),"",YourFormula)
or, in Excel2007 and newer:
=iferror(YourFormula,"")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel