ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Vlookup returns #N/A (https://www.excelbanter.com/excel-discussion-misc-queries/176068-vlookup-returns-n.html)

Joe M.

Vlookup returns #N/A
 
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

Vlookup returns #N/A
 
=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

John Moore

Vlookup returns #N/A
 
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

Vlookup returns #N/A
 
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

Gord Dibben

Vlookup returns #N/A
 
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




All times are GMT +1. The time now is 10:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com