| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to convert #na to 0 when using vlookup
When I use Vlookup, #NA returned if the vulue is not found. I need help to
convert #NA to zero or blank. Please help and thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to convert #na to 0 when using vlookup
try =if(isna(your_vlookup),0,your_vlookup) "Diane" wrote: When I use Vlookup, #NA returned if the vulue is not found. I need help to convert #NA to zero or blank. Please help and thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to convert #na to 0 when using vlookup
=IF(ISNA(vlookup),"",vlookup)
replace vlookup with your formula -- Regards, Peo Sjoblom "Diane" wrote in message ... When I use Vlookup, #NA returned if the vulue is not found. I need help to convert #NA to zero or blank. Please help and thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: Can I convert #N/A to 0 in the VLOOKUP( ) formula ? | Excel Discussion (Misc queries) | |||
| Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
| Convert Range name in cell for VLookup | Excel Worksheet Functions | |||
| Convert VLOOKUP to absolute cell reference | Excel Discussion (Misc queries) | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Hybrid Mode
