ExcelBanter - Using VLookup and format the #N/A result

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Using VLookup and format the #N/A result (https://www.excelbanter.com/excel-discussion-misc-queries/258128-using-vlookup-format-n-result.html)

rvtrails

Using VLookup and format the #N/A result

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

Using VLookup and format the #N/A result

=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

rvtrails

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

All times are GMT +1. The time now is 02:08 AM.