A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

To show 0 instead #Value!



 
 
Thread Tools Display Modes
  #1  
Old March 4th 09, 04:11 PM posted to microsoft.public.excel.misc
user
external usenet poster
 
Posts: 44
Default To show 0 instead #Value!

Hello

I am trying to do a vlookup using if(isNa... and if isn't not found, I want
it to show a zero instead of #VAlue!. Not sure why #Value is showing up, as
opposed to the #N/A.
--
Thanks
Ads
  #2  
Old March 4th 09, 04:19 PM posted to microsoft.public.excel.misc
Sheeloo[_3_]
external usenet poster
 
Posts: 1,805
Default To show 0 instead #Value!

VLOOKUP might be returning #VALUE
ISNA only checks for #N/A error... Use ISERROR if you want to suppress
#VALUE errors too...



"user" wrote:

> Hello
>
> I am trying to do a vlookup using if(isNa... and if isn't not found, I want
> it to show a zero instead of #VAlue!. Not sure why #Value is showing up, as
> opposed to the #N/A.
> --
> Thanks

  #3  
Old March 4th 09, 04:53 PM posted to microsoft.public.excel.misc
Francis
external usenet poster
 
Posts: 175
Default To show 0 instead #Value!

There's a few possibly on retruning #Value, for your case, i can think of :
1) cells that are referenced by the formula contain does not contain valid
values.

2) you have supply a range instead of a value

your formula should look like this
=IF(ISNA(VLOOKUP(lookup value,table, col number,0)),"",VLOOKUP(lookup
value,table, col number,0))

If the above don't works, pls show your formula.
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis





"user" wrote:

> Hello
>
> I am trying to do a vlookup using if(isNa... and if isn't not found, I want
> it to show a zero instead of #VAlue!. Not sure why #Value is showing up, as
> opposed to the #N/A.
> --
> Thanks

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal2 temp Excel Worksheet Functions 2 December 24th 07 10:45 PM
Better example I hope how can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal2 temp Excel Discussion (Misc queries) 4 December 24th 07 02:21 AM
Better example I hope how can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal2 temp Excel Worksheet Functions 4 December 24th 07 02:21 AM
How can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal2 temp Excel Discussion (Misc queries) 2 December 14th 07 07:36 PM
How can I show radians in symbolic format in excel? like 90 degrees would show (Symbol Pi/2) tia sal2 temp Excel Worksheet Functions 2 December 14th 07 07:36 PM


All times are GMT +1. The time now is 07:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.