When a match can't be found I get #N/A. I would like the results to be blank
if there's no match. Can you help?

=if(isna(yourvlookupformula),"",yourvlookupformula )

In xl2007, you can use:
=iferror()

Joe M. wrote:

When a match can't be found I get #N/A. I would like the results to be blank
if there's no match. Can you help?

--

Dave Peterson

or try
=if(iserror(yourlookupformula)),"0",(yourlookupfor mula))

"Dave Peterson" wrote:

=if(isna(yourvlookupformula),"",yourvlookupformula )

In xl2007, you can use:
=iferror()

Joe M. wrote:

When a match can't be found I get #N/A. I would like the results to be blank
if there's no match. Can you help?

--

Dave Peterson

Usually when I want a 0 returned, I want it as a real number--not text.

I'd use:
=if(iserror(yourlookupformula)),0,(yourlookupformu la))
(w/o the double quotes)

But in this case, the user wanted a cell that would look blank.

John Moore wrote:

or try
=if(iserror(yourlookupformula)),"0",(yourlookupfor mula))

"Dave Peterson" wrote:

=if(isna(yourvlookupformula),"",yourvlookupformula )

In xl2007, you can use:
=iferror()

Joe M. wrote:

When a match can't be found I get #N/A. I would like the results to be blank
if there's no match. Can you help?

--

Dave Peterson


--

Dave Peterson

I suggest not using the iserror function which could mask errors other than the
#N/A

My 2 cents added.


Gord Dibben MS Excel MVP

On Fri, 08 Feb 2008 09:47:39 -0600, Dave Peterson
wrote:

Usually when I want a 0 returned, I want it as a real number--not text.

I'd use:
=if(iserror(yourlookupformula)),0,(yourlookupform ula))
(w/o the double quotes)

But in this case, the user wanted a cell that would look blank.

John Moore wrote:

or try
=if(iserror(yourlookupformula)),"0",(yourlookupfor mula))

"Dave Peterson" wrote:

=if(isna(yourvlookupformula),"",yourvlookupformula )

In xl2007, you can use:
=iferror()

Joe M. wrote:

When a match can't be found I get #N/A. I would like the results to be blank
if there's no match. Can you help?

--

Dave Peterson