![]() |
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? |
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 |
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 |
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 |
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 12:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com