| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to replae #NA with 0
HI
Any one can guide me that how to replace #NA with 0, iam using vlookup with match but i doesn't works well thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to replae #NA with 0
Hi
=IF(ISNA(VLOOKUP(...)),0,VLOOKUP(...)) or =IF(ISERROR(VLOOKUP(...)),0,VLOOKUP(...)) Arvi Laanemets "SG" wrote in message ps.com... HI Any one can guide me that how to replace #NA with 0, iam using vlookup with match but i doesn't works well thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to replae #NA with 0
On Aug 5, 1:05 pm, "Arvi Laanemets" wrote:
Hi =IF(ISNA(VLOOKUP(...)),0,VLOOKUP(...)) or =IF(ISERROR(VLOOKUP(...)),0,VLOOKUP(...)) Arvi Laanemets hi Arvi It works well thank you very much for your support SG "SG" wrote in message ps.com... HI Any one can guide me that how to replace #NA with 0, iam using vlookup with match but i doesn't works well thanks- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
