Using VLookup and format the #N/A result
Perfect!! Thank you!
"Niek Otten" wrote:
=if(isna(YourFormula),"",YourFormula)
or, in Excel2007 and newer:
=iferror(YourFormula,"")
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"rvtrails" wrote in message
...
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
|