| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Can I turn the #N/A result from a lookup function to a zero?
Can I turn the #N/A result from a lookup function to a zero?
Thanks |
|
#2
|
|||
|
|||
|
Can I turn the #N/A result from a lookup function to a zero?
= if(isError( 'yourlookupcodehere) , 0 , 'yourlookupcodehere)
"Chase" wrote: Can I turn the #N/A result from a lookup function to a zero? Thanks |
|
#3
|
|||
|
|||
|
Can I turn the #N/A result from a lookup function to a zero?
=IF(ISNA(VLOOKUP(A1,C1:D100,2,FALSE)),0,VLOOKUP(A1 ,C1:D100,2,FALSE))
Regards, Alan. "Chase" wrote in message ... Can I turn the #N/A result from a lookup function to a zero? Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I turn the #N/A result from a lookup function to a zero?
"Chase" wrote: Can I turn the #N/A result from a lookup function to a zero? Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I turn the #N/A result from a lookup function to a zero?
=IF(ISNA(your formula),0,your formula)
"mbpoet" wrote in message ... "Chase" wrote: Can I turn the #N/A result from a lookup function to a zero? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to .. | Excel Discussion (Misc queries) | |||
| Lookup Function help | Excel Discussion (Misc queries) | |||
| excel | Excel Worksheet Functions | |||
| LOOKUP function | Excel Worksheet Functions | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Hybrid Mode
