Using VLookup and format the #N/A result

  • Thread starter Thread starter rvtrails
  • Start date Start date
R

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
 
=if(isna(YourFormula),"",YourFormula)
or, in Excel2007 and newer:
=iferror(YourFormula,"")
 
Perfect!! Thank you!

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel
 
Back
Top