| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
NA -Errors to show 0
Is there a way when you perform a VLook-up and the value is not found that
the formula will produce 0 instead of NA |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NA -Errors to show 0
=IF(ISERROR(VLOOKUP([your vlookup]),0,VLOOKUP([your vlookup]))
Dave -- Brevity is the soul of wit. "Newbee" wrote: Is there a way when you perform a VLook-up and the value is not found that the formula will produce 0 instead of NA |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NA -Errors to show 0
hello
=if(isna("yourVlookup_formula"),0,("yourVlookup_fo rmula")) -- ***** birds of the same feather flock together.. "Newbee" wrote: Is there a way when you perform a VLook-up and the value is not found that the formula will produce 0 instead of NA |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NA -Errors to show 0
Thank you very much!!
"Dave F" wrote: =IF(ISERROR(VLOOKUP([your vlookup]),0,VLOOKUP([your vlookup])) Dave -- Brevity is the soul of wit. "Newbee" wrote: Is there a way when you perform a VLook-up and the value is not found that the formula will produce 0 instead of NA |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NA -Errors to show 0
Just as long as you know that with ISERROR all errors will return 0, not just
the NA. You may be hiding something you should know about. The ISNA trap will return 0 for data not found. =IF(ISNA(VLOOKUP([your vlookup]),0,VLOOKUP([your vlookup])) Gord Dibben MS Excel MVP On Tue, 30 Jan 2007 09:15:01 -0800, Newbee wrote: Thank you very much!! "Dave F" wrote: =IF(ISERROR(VLOOKUP([your vlookup]),0,VLOOKUP([your vlookup])) Dave -- Brevity is the soul of wit. "Newbee" wrote: Is there a way when you perform a VLook-up and the value is not found that the formula will produce 0 instead of NA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macros Don't Show On Commands List and 'Normal.dot' | Excel Worksheet Functions | |||
| Tracking Errors | Excel Worksheet Functions | |||
| Show data used and percent label | Charts and Charting in Excel | |||
| leading zeros are not showing in the formula bar but do show in ce | Excel Discussion (Misc queries) | |||
| Show values from other sheet | Excel Worksheet Functions | |||
Linear Mode
